Re: 12.2 create role raises ORA-00972

Hey Tim, Hope all is well with y'all.

I found it, MAX_STRING_SIZE=STANDARD. changed it to MAX_STRING_SIZE=EXTENDED in upgrade mode, then ran $ORACLE_HOME/rdbms/admin/utl32k.sql

This was my demo database that I upgraded from 12.1 -> 12.2. I had set COMPATIBLE=12.2.0.1, but missed the max_string_size parameter. One more thing to add to my checklist.

-Rob

On 7/22/2017 2:25 PM, Tim Gorman wrote:
>
> 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_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
>

-- 
================================
"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