Forum OpenACS Q&A: Re: Oracle export - full database vs. per user

Posted by Sebastiano Pilla on
In a certain sense, yes, by doing a user export you will miss the data you're outlining. This is the data dictionary, in other words the logical structure of your database: the informations about tablespaces, users, and so on.

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!