ExaGridDba

can't create oracle user with name > 30 characters

Jun 28th, 2016
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. [oracle@stormking cdb12102 ~]$ echo -n Supercalifragilisticexpialidocious | wc -c
  2. 34
  3. [oracle@stormking cdb12102 ~]$ sqlplus /nolog
  4.  
  5. SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 28 23:17:06 2016
  6.  
  7. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  8.  
  9. SQL> conn u/u@stormking:1521/pdbm
  10. Connected.
  11. SQL> select char_length from dba_tab_columns where owner = 'SYS' and table_name = 'USER$' and column_name = 'NAME';
  12.  
  13. CHAR_LENGTH
  14. -----------
  15. 128
  16.  
  17. SQL> create user "Supercalifragilisticexpialidocious" identified by p;
  18. create user "Supercalifragilisticexpialidocious" identified by p
  19. *
  20. ERROR at line 1:
  21. ORA-00972: identifier is too long
Advertisement
Add Comment
Please, Sign In to add comment