SQLcl Breaks noncdb_to_pdb.sql (?)

Today I finished off a project where I migrated a database from a non-container 12.1.0.2 database to a pluggable 19.9 database. The final step: run noncdb_to_pdb.sql.

I’ve been using SQLcl without any issues, but for some reason SQLcl (20.2, the latest version) produced an error where SQL Plus didn’t!

SYS@CDB$ROOT AS SYSDBA> STORE SET ncdb2pdb.settings.sql REPLACE
 SP2-0603: Illegal STORE command
 Usage: STORE {SET} filename[.ext] [CRE[ATE]|REP[LACE]|APP[END]]

SQL Plus on the other hand ran the same command just fine:

SYS@aurdcon AS SYSDBA> STORE SET ncdb2pdb.settings.sql REPLACE
 Wrote file ncdb2pdb.settings.sql

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: