Med Java

User Tools

Site Tools

Trace:
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
Last revisionBoth sides next revision
database:oracle:import-dump [2018/03/04 22:26] – [Create dump directory] odeftadatabase:oracle:import-dump [2018/07/26 11:46] – [Execute the import command] odefta
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.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1