Until now my understanding for EXPDP/IMPDP was that
if the user performing import has 'IMPORT FULL DATABASE' privilege, it'll
create the users/schemas in the target database. I needed to export (expdp)
schema from one machine and import (impdp) it to another machine. I just wanted impdp to create schema on target database.
While doing import i
encountered error
$ impdp system/oracle123
directory=TEST_DIR dumpfile=test.dmp logfile=impdptest.log
.......
Starting
"SYSTEM"."SYS_IMPORT_FULL_01": system/********...
Showing posts with label EXPDP/IMPDP. Show all posts
Showing posts with label EXPDP/IMPDP. Show all posts
Saturday, 22 February 2014
Identify the Tablespace names from EXPDP dump file
I got request from development team to
import some old data in UAT region.The expdp dump file received from backup team was without log file and i have no access to the export file's source DB. I wanted to import that
dumpfile into UAT DB and i do not know the tablespace names required to do
so.
Solution:
Use the sqlfile option present in impdp utility. This
option will write all the SQL DDL to a specified file instead of executing
them.
$ impdp scott/tiger directory=exp_dir
dumpfile=scott.dmp sqlfile=script.sql
Import:...