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 revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
database:oracle:import-dump [2018/03/04 22:25]
odefta
database:oracle:import-dump [2018/07/26 11:45]
odefta [Optional - create a dedicated tablespace, otherwise use the default one]
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 =====
database/oracle/import-dump.txt · Last modified: 2018/07/26 11:46 by odefta