-
Full export omitting one schema.
We have approx. 10 schemas in our database. The amount of tables throughout the schemas range from 5 to over 300.
I need to export all of these except for one on a nightly basis.
(The one I need to omit has approx. 100 tables).
Is there a way in Oracle 9.2 to take an export and omit just one schema?
Thanks,
smoothyc
-
OWNER
Default: undefined
Indicates that the Export is a user-mode Export and lists the users whose objects will be exported. If the user initiating the export is the DBA, multiple users may be listed.
Just list every schema except the one you want to omit.
MH
I remember when this place was cool.
-
Mr. Hanky,
Thanks for the info. I was trying to avoid that route but it seems to be the only/best way right now.
Thanks again,
smoothyc....
-
How about exporting the different schema's in parallel as separate processes? Would be faster, and pretty flexible.
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
|