With Oracle, I want to do a full database export,
except for
one user/schema. Unfortunately, there seems to be no easy way to tell
Oracle to do that. So, it looks like what I need to do is get a list
of all the users I want to export, and do a separate export for each
one. So far so good.
But, will I miss any data by doing it that way, rather than
using a full database export? In particular, I'm wondering about the
stuff I see at the top of my full database export file - see below.
This stuff will perhaps come along with the SYSTEM user?
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Direct Path ...
