using SQL option in export

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:

---

Originally posted by nirasha
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

---