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