Re: 12.2 create role raises ORA-00972

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: rob@xxxxxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 22 Jul 2017 12:25:15 -0600

What is the value returned from "show parameter compatible" in SQL*Plus?


On 7/22/17 10:36, Rob Lockard wrote:


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@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@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@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: @YourNavionPilot

Other related posts: