Differences

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

--- database:oracle:import-dump [2018/03/04 20:25] – created odefta
+++ database:oracle:import-dump [2023/07/04 16:36] (current) – external edit 127.0.0.1
@@ 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 37: / Line 38: @@
 Next:
-- Copy dump file in the dump directory
+  * Copy dump file in the dump directory
-- Check the dump log file and note the schema and the tablespaces used, we'll need to remap them to match the existing schema and tablespaces
+  * Check the dump log file and note the schema and the tablespaces used, we'll need to remap them to match the existing schema and tablespaces
 ===== Execute the import command =====
@@ 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>
 Here we can have multiple remap_ parameters.
-Note:
-----
 NOTE: If no log option is specified, an import.log file will be created by default in the dump folder.