ORA-14183: TABLESPACE DEFAULT can be specified only for
Composite LOCAL index



ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index..

Answer / guest

Cause: User attempted to specify TABLESPACE DEFAULT for a
partition of a Range/System/Hash partitioned LOCAL index
object, which is illegal.

Action: Replace TABLESPACE DEFAULT with TABLESPACE <ts_name>
or remove it.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31455: nothing to ALTER

1 Answers  


PLS-00550: character set specification is not allowed for this type

1 Answers  


ORA-14079: illegal option for a partition marked Index Unusable

1 Answers  


ORA-39114: Dump files are not supported for string jobs

1 Answers  


RMAN-06032: at least 1 channel of TYPE DISK must be allocated to execute a COPY command

1 Answers  






ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]

1 Answers  


EXP-00068: tablespace string is offline

1 Answers  


PCB-00302: This statement is not supported by ANSI

1 Answers  


DRG-50805: failed to close cursor

1 Answers  


PLS-00462: nested subprogram 'string' has to be REPEATABLE

1 Answers  


ORA-06112: NETTCP: invalid buffer size

1 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  


Categories