DATAPUMP-export/import issue
If I am exporting full database level using SYS or SYSTEM and plan to import on different database server using the SYS or SYSTEM privileged users, do I have to create tablespaces first?
I am trying various ways to import all the production data into another database (testDB) on different server.
First attempt: IMPORT OF schema - TEST TRIAL
This export dumpfile was just SCHEMAS. the necessary schemas to be imported.
Second attempt was Tablespaces with these commands:
expdp hr/hr@patcare DIRECTORY=EXPDP DUMPFILE=FULLDB02.DMP LOGFILE=FULLDB002.LOG FULL=Y
impdp hr/hr@patcare DIRECTORY=IMPDP DUMPFILE=FULLDB02.DMP LOGFILE=FULLDB002.LOG TABLESPACES=APP_DATA,APP_DATA1