12.2 create role raises ORA-00972
From: Rob Lockard <rob_at_oraclewizard.com>
Date: Sat, 22 Jul 2017 12:36:12 -0400
Message-ID: <45671571-2ff1-5bab-f9d2-5c8464fbf2cf_at_oraclewizard.com>
Has anyone encountered this? I can't find any reference to it in metalink. I should be able to create a role with a name up to 128 characters. -Rob
Date: Sat, 22 Jul 2017 12:36:12 -0400
Message-ID: <45671571-2ff1-5bab-f9d2-5c8464fbf2cf_at_oraclewizard.com>
Has anyone encountered this? I can't find any reference to it in metalink. I should be able to create a role with a name up to 128 characters. -Rob
RLOCKARD_at_demo1 > desc dba_roles
Name Null? Type ------------------- -------- ------------- ROLE NOT NULL VARCHAR2(128) ROLE_ID NOT NULL NUMBER PASSWORD_REQUIRED VARCHAR2(8) AUTHENTICATION_TYPE VARCHAR2(11) COMMON VARCHAR2(3) ORACLE_MAINTAINED VARCHAR2(1) INHERITED VARCHAR2(3) IMPLICIT VARCHAR2(3)
RLOCKARD_at_demo1 > create role Use_API_Select_To_Be_Deleted_From_t;
Error starting at line : 1 in command -
create role Use_API_Select_To_Be_Deleted_From_t
Error report -
ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
**Cause: An identifier with more than 30 characters was specified.*
*Action: Specify at most 30 characters.
RLOCKARD_at_demo1 >
-- ================================ "The question isn't who is going to let me; it's who is going to stop me."Ayn Rand Robert P. Lockard www.oraclewizard.com (c) 571.276.4790 Twitter: _at_YourNavionPilot -- http://www.freelists.org/webpage/oracle-l Received on Sat Jul 22 2017 - 18:36:12 CEST