Database Administration (MOSC)

MOSC Banner

impdp prerequisites and syntax for PDB

edited Feb 29, 2020 11:06AM in Database Administration (MOSC) 23 commentsAnswered ✓

Hello,

I exported schema from my old instance (Oracle 11) using user/pass. Dump file has been copied and new instance is on Oracle 18 level (PDB).

I assume that I need to do following to do impdp: (Correct me if I am wrong)

1. Switch to container PDB

2. Create tablespace for schema

3. Create user with pass

4. Create directory and give rights for user

5. Run impdp command. How should I specify in such command PDB name ?

Thanks in advance.

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