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

Both sides previous revisionPrevious revision
Next revision
Previous revision
database:oracle:import-dump [2018/03/04 22:26] – [Create dump directory] odeftadatabase:oracle:import-dump [2023/07/04 19:36] (current) – external edit 127.0.0.1
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 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>
  
database/oracle/import-dump.1520195184.txt.gz · Last modified: 2023/07/04 19:36 (external edit)