Re: Problem with import of a ~2Gig table

Hi

You can export the table from the first database with this command very fast:

exp user/pass file=file.dmp full=y log=file.log direct=y

If you like to import the Table fast you should make a rollback segment with the same size as the export file + 10 % more. Set all other rollback segments offline an start the import with the following command:

imp user/pass file=file.dmp full=y log=file.log

When you are rar in space then you could add the parameter "commit=y" to the import. This needs much longer as the import with the big rollback segment.

If you change the directory to "$ORACLE_HOME/rdbms/lib" and type "make impst" a single server import is generated. You can use the impst instead of imp to import data faster too.

 Regards

 Mario Bucsics

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!