-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|