Re: Cloning DB to different UNIX platform

>
> The full export can only be done as SYS. Importing such a dump file in
> one step would render everything in the SYSTEM Tablespace - bad. Doing
> import one schema at a time would avoid this problem, but requires
> more work, since users, profiles, privileges and roles should be
> created beforehand - prone to errors.
>
> Even doing the export with the appropriate option, statistics must be
> generated in an additional step after the import. Besides,
> export/import gives you at times some headaches with character sets,
> index names, constraints, triggers...

The export should be done in full mode.
The import should be done with the same version as the export has been done. You should create on the target database (with preferred the same RDBMS version) a database with the same tablespaces as the originally databases.

When all these requirements are met: a succesful import can be done.

>
> Well, it CAN be done, but, as I said, prone to errors.
>
> Bye
> Rick
Received on Mon Aug 19 2002 - 10:28:25 CDT