ExaGridDba

ORA-01450 while indexing 12c extended type

Jan 12th, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SQL> create table t32k
  2. 2 (
  3. 3 ve varchar2 (32767)
  4. 4 )
  5. 5 tablespace users;
  6.  
  7. Table created.
  8.  
  9. SQL> select block_size from dba_tablespaces where tablespace_name = 'USERS';
  10.  
  11. BLOCK_SIZE
  12. ----------
  13. 8192
  14.  
  15. SQL> create index t32k_idx on t32k ( ve );
  16. create index t32k_idx on t32k ( ve )
  17. *
  18. ERROR at line 1:
  19. ORA-01450: maximum key length (6398) exceeded
  20.  
  21. The ORA-01450 is the expected, documented behavior.
Advertisement
Add Comment
Please, Sign In to add comment