Differences

This shows you the differences between two versions of the page.

oracle:import_dump_file [November 30, 2017 8:01 am]
sqlines
oracle:import_dump_file [November 30, 2017 8:10 am] (current)
sqlines
Line 26: Line 26:
Then modify the generated //script.sql// file, remove comments and change the tablespace name to require value. Then modify the generated //script.sql// file, remove comments and change the tablespace name to require value.
 +
 +  * **Import**
 +
 +After you created the tables in the required tablespace, you can run IMP with IGNORE=y option to import data:
 +
 +<code>
 +IMP system/password FILE=file.dmp FROMUSER=scott TOUSER=john IGNORE=y
 +</code>