User Tools

Site Tools


database:oracle:import-dump

Differences

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

Link to this comparison view

Next revision
Previous revision
database:oracle:import-dump [2018/03/04 22:25]
odefta created
database:oracle:import-dump [2018/07/26 11:46]
odefta [Execute the import command]
Line 6: Line 6:
 CREATE TABLESPACE "NEWTBS" CREATE TABLESPACE "NEWTBS"
 NOLOGGING 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 EXTENT MANAGEMENT LOCAL
 ONLINE ONLINE
Line 37: Line 38:
  
 Next: 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 ===== ===== Execute the import command =====
Line 44: Line 45:
 From the machine where Oracle is installed, run the import: From the machine where Oracle is installed, run the import:
 <code> <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> </code>
  
 Here we can have multiple remap_ parameters. 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. NOTE: If no log option is specified, an import.log file will be created by default in the dump folder.
  
database/oracle/import-dump.txt · Last modified: 2018/07/26 11:46 by odefta