Database Utilities (MOSC)

MOSC Banner

Expdp throwing an error in brand new database(Version 12.2.0.1.0) just created

edited Apr 6, 2018 1:38PM in Database Utilities (MOSC) 7 commentsAnswered ✓

Hi gurus,

I have created a brand new 12.2.0.1.0 EE database on el6uek.x86_64 server.

I plan to use this database for production once I complete all set up.

At this moment I am testing whether I can do full database export using expdp utility.

For doing this I have created a user called dp_user and granted him the following grants.

---

grant  DATAPUMP_EXP_FULL_DATABASE to dp_user;

grant datapump_imp_full_database to dp_user;

GRANT read, write on directory dump_dir TO dp_user;

---

Then I ran the following export statement which is embedded in sql script:

Tagged:

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