ORA-25186: INCLUDING clause specified for index-organized
table without OVERFLOW



ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW..

Answer / guest

Cause: INCLUDING clause of a CREATE TABLE is an valid option
only for index-organized tables with OVERFLOW clause (at
creation time) or if an OVERFLOW segment already exists (at
ALTER time).

Action: Specify OVERFLOW clause for the index-organized
table : For ALTER, perform ADD OVERFLOW first.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

1 Answers  


DRG-10533: invalid user name: string

1 Answers  


ORA-22810: cannot modify object attributes with REF dereferencing

1 Answers  


PLS-00617: at least one result in the CASE expression must not be NULL

1 Answers  


ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  






KUP-04044: error positioning file string

1 Answers  


ORA-06558: buffer in dbms_pipe package is full. No more items allowed

1 Answers  


ORA-16734: Error executing dbms_logstdby.skip_error procedure

1 Answers  


ORA-12900: must specify a default temporary tablespace for a locally managed database

1 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


ORA-07251: spcre: semget error, could not allocate any semaphores.

1 Answers  


ORA-38417: attribute set string does not exist

1 Answers  


Categories