database:oracle:import-dump
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
database:oracle:import-dump [2018/03/04 22:25] – created odefta | database:oracle:import-dump [2018/07/26 11:46] – [Execute the import command] odefta | ||
---|---|---|---|
Line 6: | Line 6: | ||
CREATE TABLESPACE " | CREATE TABLESPACE " | ||
NOLOGGING | NOLOGGING | ||
- | DATAFILE ' | + | DATAFILE ' |
+ | 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 | + | |
===== 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: | ||
< | < | ||
- | impdp SNT611/ | + | impdp SNT611/ |
+ | remap_schema=SENTINEL_MGR: | ||
</ | </ | ||
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: 2023/07/04 19:36 by 127.0.0.1