EXP selecting tables' rows

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

EXP selecting tables' rows

Ciro
Hello, is it possible to export (using exp command) a Scheme EXCLUDING SOME tables' rows?
Reply | Threaded
Open this post in threaded view
|

Re: EXP selecting tables' rows

ErmanArslansOracleBlog
Administrator
with expdp yes.
with exp no!

But, if you still want to do this with exp command; you can do it by using the TABLES argument. This way you can tell exp to export only the tables that you want to be exported! This way, the other list of tables that you want to exclude from your export process, will be excluded from your export process indirectly.
Reply | Threaded
Open this post in threaded view
|

Re: EXP selecting tables' rows

ErmanArslansOracleBlog
Administrator
Also, as for excluding rows please see -> QUERY argument.