Database Administration (MOSC)

MOSC Banner

Single-quotes not working in SQL statement run from scheduled SQL*Plus script or PL/SQL script.

edited Mar 19, 2019 5:01AM in Database Administration (MOSC) 11 commentsAnswered

I have an Oracle 12.2 multi-tenant database that uses encryption to encrypt a table space.   Every night I am required to refresh one of the pluggable databases from a production database.  I have been doing that using a simple 'create pluggable database' command from the target CDB that looks like this:

DEVCDB:

create pluggable database DEVPDB1 from PRDPDB1@clone_link keystore identified by 'PassWord1234';

PRDCDB contains the production PRDPDB1 referenced above.  The clone_link database link connects to the PRDPDB1 container and creates a copy of it in the DEVCDB container.

That command above has been working perfectly fine for the past year, but after applying the latest January 2019 PSU I get an error due to the single-quotes in the command.   I have tried the same command with no single-quotes and using double-quotes.  Same error -- It will respond with "invalid password."

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