Testcase:
-- SYS in PDB:
create user "martinberx" identified by "berx123#";
grant connect,dba to "martinberx";
- - as user martinberx
connect "martinberx"/"berx123#"@127.0.0.1/freepdb1
alter session set sql_trace=TRUE;
CREATE TABLE TICKETSALES(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(100),
CAPACITY NUMBER RESERVABLE CONSTRAINT MINIMUM_CAPACITY CHECK (CAPACITY >= 10)
);
Error starting at line : 1 in command -
CREATE TABLE TICKETSALES(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(100),
CAPACITY NUMBER RESERVABLE CONSTRAINT MINIMUM_CAPACITY CHECK (CAPACITY >= 10)
)
Error report -
ORA-01918: user 'MARTINBERX' does not exist
01918. 00000 - "user '%s' does not exist"
*Cause: User does not exist in the system.
*Action: Verify the user name is correct.
The tracefile shows:
PARSING IN CURSOR #139928154398112 len=81 dep=2 uid=0 oct=3 lid=0 tim=81440320823 hv=3232580465 ad='898beff0' sqlid='grfx7r30auhvj'
select 1 from sys.bc$ bc, sys.user$ ur where bc.user#= ur.user# and ur.name = :1
END OF STMT
PARSE #139928154398112:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1239444311,tim=81440320822
BINDS #139928154398112:
Bind#0
oacdty=01 mxl=32(10) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7f438fefd100 bln=32 avl=10 flg=05
value="MARTINBERX"
obviously, the value for Bind#0 should be in lowercase.
in a working execution (with user in full uppercase) this section in the tracefile
PARSING IN CURSOR #140104630834056 len=264 dep=1 uid=131 oct=1 lid=131 tim=6500712880 hv=2509655550 ad='7f6ca62fb520' sqlid='69wn4waatcmgy'
create table BERX.SYS_RESERVJRNL_98174 (ORA_SAGA_ID$ RAW(16), ORA_TXN_ID$ RAW(8), ORA_STATUS$ CHAR(12), ORA_STMT_TYPE$ CHAR(16), ID NUMBER NOT NULL, CAPACITY_OP CHAR(7), CAPACITY_RESERVED NUMBER) segment creation deferred STORAGE(INITIAL 16K NEXT 16K)
END OF STMT
You can see the owner BERX is not enclosed in " - this might be part of the issues.
How it should be: (example from the same good tracefile)
PARSING IN CURSOR #140104630904624 len=81 dep=1 uid=131 oct=9 lid=131 tim=6500808350 hv=797169428 ad='629dd7b0' sqlid='2pat6ghrs7psn'
CREATE UNIQUE INDEX "BERX"."SYS_C008246" on "BERX"."TICKETSALES"("ID") NOPARALLEL
END OF STMT
hth,
Martin