Normally common user are started with
C## in 12c. But this can be eliminated by using hidden parameter below method. SQL> alter
system set
"_common_user_prefix"='v##' scope=spfile; System altered. SQL> create
user v## identified by test;create user v## identified by test *ERROR at line 1:ORA-65096: invalid common user or role
nameSolutions:-SQL> create
pfile from spfile;
File created. SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down. #####Opened the pfile and modify the
value ora12c._common_user_prefix='V##' SQL> startup pfile='C:\app\XXXXXX\product\12.1.0\dbhome_1\database\INITora12c.ORA';ORACLE instance started. Total System Global Area 1068937216
bytesFixed Size 2410864 bytesVariable Size 666896016 bytesDatabase Buffers 394264576 bytesRedo Buffers 5365760 bytesDatabase mounted.Database opened.SQL> show con_name CON_NAME------------------------------CDB$ROOTSQL> create
user v## identified by test; User created.
No comments:
Post a Comment