Hi,
the ddl command reports “Object … not found”. When I fully qualify (schema.object_name) the ddl command works just fine.
Here is my setup:
common user defined in cdb
authentication is externally using Centeral Managed Users (CMU)
example:
username: c##dummy
external_name: cn=Dummy,ou=…..
connection to the database is: sql dummy@db.domain.com
show user
C##DUMMY
ddl my_table
Object my_table not found
ddl C##DUMMY.my_table
CREATE TABLE “C##DUMMY”."MY_TABLE"
( "COLUMNA" VARCHAR2(256),
"COLUMNB" VARCHAR2(256),
…
Any idea what the issue is and how to convince sqlcl to work without to fully qualify and without changing the setup?
It's just annoying to fully qualify.
Thanks,
Knut