Database Utilities (MOSC)

MOSC Banner

DATAPUMP-export/import issue

edited Jun 17, 2021 8:25PM in Database Utilities (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center