"It lets you control the commit frequency; something impossible in export/import."
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch02 .htm#40480 COMMIT Default: N Specifies whether Import should commit after each array insert. By default, Import commits only after loading each table, and Import performs a rollback when an error occurs, before continuing with the next object. If a table has nested table columns or attributes, the contents of the nested tables are imported as separate tables. Therefore, the contents of the nested tables are always committed in a transaction distinct from the transaction used to commit the outer table. If COMMIT=N and a table is partitioned, each partition and subpartition in the Export file is imported in a separate transaction. Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports. Specifying COMMIT=Y is advisable if the table has a uniqueness constraint. If the import is restarted, any rows that have already been imported are rejected with a nonfatal error. If a table does not have a uniqueness constraint, Import could produce duplicate rows when you reimport the data. For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, DATE, or type columns, array inserts are not done. If COMMIT=Y, Import commits these tables after each row. -----Original Message----- Sent: Friday, January 17, 2003 8:45 AM To: Multiple recipients of list ORACLE-L You could use COPY command. Create a new table exactly as the old table in the new tablespace from the DDL scripts. Then use the COPY command to insert rows. It lets you control the commit frequency; something impossible in export/import. HTH. Arup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
