Differences

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

--- database:oracle:import-dump [2018/03/04 22:26]
odefta [Create dump directory]
+++ database:oracle:import-dump [2018/07/26 11:46] (current)
odefta [Execute the import command]
@@ Line 6: / Line 6: @@
 CREATE TABLESPACE "NEWTBS"
 NOLOGGING
-DATAFILE 'C:\DEV\ORACLE\ORADATA\MJ\5E1C9A696BD54020916EA3277599305C\DATAFILE\NEWTBS' SIZE 307200K AUTOEXTEND ON
+DATAFILE 'C:\DEV\ORACLE\ORADATA\MJ\5E1C9A696BD54020916EA3277599305C\DATAFILE\NEWTBS'
+SIZE 307200K AUTOEXTEND ON
 EXTENT MANAGEMENT LOCAL
 ONLINE
@@ Line 44: / Line 45: @@
 From the machine where Oracle is installed, run the import:
 <code>
-impdp SNT611/snt611@PMJ DIRECTORY=dump DUMPFILE=exp_ASENTIN2_scm_15Mar072114.dmp remap_schema=SENTINEL_MGR:SNT611 remap_tablespace=SENTINEL_AA:DATA
+impdp SNT611/snt611@PMJ DIRECTORY=dump DUMPFILE=exp_ASENTIN2_scm_15Mar072114.dmp
+remap_schema=SENTINEL_MGR:SNT611 remap_tablespace=SENTINEL_AA:DATA
 </code>

Med Java