tailieunhanh - ORACLE8i- P14

ORACLE8i- P14: We want information information.” Possibly you recognize these words as the primary interest of a somewhat clandestine group, and as told by a character called Number 2 to Patrick McGoohan’s character Number 6 (in the old TV show The Prisoner). Indeed, in this day, information is king, and the speedy, accurate, and reliable retrieval of this information is paramount. | 514 CHAPTER 11 ORACLE LOGICAL BACKUP AND RECOVERY . importing SYSTEM S objects into SYSTEM . importing SCOTT s objects into SCOTT . . importing table EMP 14 rows imported Import terminated successfully without warnings. Here we want to take a table that was exported from the scott schema and import it into the new_scott schema. D ORACLE admin ORA817 exp imp system robert tables emp fromuser scott touser new_scott file ignore y Import Release - Production on Sun Aug 26 18 11 50 2001 c Copyright 2000 Oracle Corporation. All rights reserved. Connected to Oracle8i Enterprise Edition Release - Production With the Partitioning option JServer Release - Production Export file created by EXP0RT via conventional path import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set . importing SCOTT s objects into NEW_SCOTT . . importing table EMP 43 rows imported Import terminated successfully without warnings. Row Array Type Commits when Importing By default Oracle will commit INSERT operations after each table insert. If a large table is being inserted into a tremendous amount of undo rollback will be generated during such operations. In a very large operation you may generate more undo than there is rollback segment space available which will cause the import to fail and the rows imported into the object will be rolled back. To avoid such a problem Oracle provides the COMMIT parameter with the Import utility. When the COMMIT parameter is set to Y Oracle will commit the rows as they are being inserted. Oracle writes rows during the import process using an array-type insertion process importing many rows in one array operation. When COMMIT is set to Y these rows are committed during every array insert. This way several rows will be inserted at a time and then will be committed. Please purchase PDF SplibMJe 9e to removebthis watermark. THE ORACLE IMPORT UTILITY 515 Support for Multiple Export .