Login  Register

EXP selecting tables' rows

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

EXP selecting tables' rows

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

Re: EXP selecting tables' rows

ErmanArslansOracleBlog
Administrator
5731 posts
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
| More
Print post
Permalink

Re: EXP selecting tables' rows

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