For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
i run this query creating use
CREATE USER sms01 IDENTIFIED BY sms01;i got Error report:SQL Error: ORA-65096: invalid common user or role namebut when i run create user c##sms01 identified by sms01; is ok how can i create user without c## in 12c
CREATE USER sms01 IDENTIFIED BY sms01;
i got
Error report:
SQL Error: ORA-65096: invalid common user or role name
but when i run
create user c##sms01 identified by sms01; is ok how can i create user without c## in 12c