DBA Hub

📋Steps in this guide1/3

Create oracle 12c user without c##

We can create user in oracle 12c without c## but this is not recommended way. Oracle 12c has two kind of user called common user and local user. Still we can

oracle configurationintermediate
by OracleDba
11 views
1

Overview

We can create user in oracle 12c without c## but this is not recommended way. Oracle 12c has two kind of user called common user and local user. Still we can create oracle 12c user without c## by setting hidden parameter like below. SQL> select * from v$version; BANNER CON_ID ——————————————————————————– ———- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production 0 PL/SQL Release 12.1.0.2.0 – Production 0
2

Section 2

CORE 12.1.0.2.0 Production TNS for 64-bit Windows: Version 12.1.0.2.0 – Production 0 NLSRTL Version 12.1.0.2.0 – Production SQL> create user orcldata identified by orcldata; create user orcldata identified by orcldata *
3

Section 3

ERROR at line 1: ORA-65096: invalid common user or role name SQL> alter session set “_ORACLE_SCRIPT”=true; Session altered. SQL> create user orcldata identified by orcldata; User created.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!