using SQL option in export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: using SQL option in export

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    I need some help in exporting a schema. I want to use the query parameter in the exp command. My query looks something like:
    select * from cat where id in
    (select child_cat_id
    from cat_rel
    connect by parent_cat_id = prior child_cat_id
    start with parent_cat_id in (select cat_id from store_root_cat where store_id = 14))

    I need to bring in all the records from the tables that match this query. I need other tables too. How do I do this?

    Thanks,
    Nirasha

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    The only condition which i know of is the table should have the columns listed in where clause.And can be used only at table level export.

  3. #3
    Join Date
    Apr 2000
    Location
    Upper Marlboro, MD, USA
    Posts
    10

    Cool

    You must use the create table as select... to create a new table containing the data you want then export the new table along with any others using the tables clause.

    exp user@db_name tables=owner.table_name ...



    [QUOTE][i]Originally posted by nirasha [/i]
    [B]I need some help in exporting a schema. I want to use the query parameter in the exp command. My query looks something like:
    select * from cat where id in
    (select child_cat_id
    from cat_rel
    connect by parent_cat_id = prior child_cat_id
    start with parent_cat_id in (select cat_id from store_root_cat where store_id = 14))

    I need to bring in all the records from the tables that match this query. I need other tables too. How do I do this?

    Thanks,
    Nirasha [/B][/QUOTE]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width