Full export omitting one schema.

[smoothyc]

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

[Mr.Hanky]

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

[smoothyc]

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....

[slimdave]

How about exporting the different schema's in parallel as separate processes? Would be faster, and pretty flexible.