Forum OpenACS Q&A: Oracle export - full database vs. per user
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 ...
AFAIK, the data dictionary is owned by SYS, not by SYSTEM, so you don't gain anything by exporting the SYSTEM user. And do not even think for a minute about exporting SYS from one database and importing it into another!