Database Security Products (MOSC)

MOSC Banner

Export/Import of schema from PDB as Job without entering the password

edited Mar 26, 2020 5:29AM in Database Security Products (MOSC) 6 commentsAnswered ✓

Helo,

I start Upgrade my Databases to Version 19c.

Usual there is an os-user with Operating System Authentication. But in Oracle 19c Security Guide I find following claim:

"In a multitenant environment, you can use operating system authentication for a database administrator only for the CDB root. You cannot use it for PDBs, the application root, or application PDBs."

My expiriencies: I can create database user as identified EXTERNALLY and can connect to PDB. But If I start EXPDP/IMPDP, the tool requests the Password and starts after I press Enter - not Password:

#expdp /@SBXDB191 full=y directory=PDB_DATA_PUMP_DIR file=exp_sbxdb191_ext.dmp logfile=exp_sbxdb191_ext.log reuse_dumpfiles=yes

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