I am trying to import a DMP file into a NEW database which as no grants,users etc that are present in the export file. All I need is data and I don't care about users,grants,sequences etc.
Below is a simple import statement which I used,
IMPDP scott/********@alias directory=TEST_DIR dumpfile=godirectBackup.dm
p content=all schemas=GODIRECT logfile=imp3.log ( refer to imp-5193errors log)
But after looking at the errors, I tried to exclude certain things from the import and then the errors reduced.
IMPDP scott/********@alias dumpfile=godirectBackup.dm
e schemas=godirect directory=TEST_DIR exclude=grant,user,sequenc
e_quota logfile=mylog.log ( refer imp-1358errors log)
Even when I don’t add “exclude=tablespace” in the import statement it has the same errors as 1358 file. Now I think all the errors are pointing to godirect tablespace and the other errors are dependent on it.
Should I create a tablespace manually? Or please help me proceed. Thanks.