ORA-01771: illegal option for a clustered table



ORA-01771: illegal option for a clustered table..

Answer / guest

Cause: During a CREATE or ALTER of a clustered table, the
user attempted to enter one or more of the following
options: INITRANS, MAXTRANS, PCTFREE, PCTUSED, STORAGE,
TABLESPACE. These options may only be specified for the
cluster itself.

Action: Remove the illegal option(s).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30744: "string" is not an object table

1 Answers  


DRG-11223: Third-party filter indicates this document is password protected or encrypted.

1 Answers  


SQL*Loader-00435: invalid constant value string for nested table column string

1 Answers  


ORA-39312: illegal clean_target() call: last clone operation is failed

1 Answers  


ORA-00824: cannot set sga_target due to existing internal settings

1 Answers  


ORA-24011: cannot drop QUEUE, string should be stopped first

1 Answers  


PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  


ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.

1 Answers  


ORA-22879: cannot use the LOB INDEX clause for partitioned tables

1 Answers  


NNC-00004: connection is broken

1 Answers  


ORA-28151: more than one user name specified for command

1 Answers  


ORA-13642: The specified string string provided for string cannot be converted to a date. The acceptable date format is string.

1 Answers  


Categories