Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-14191: ALLOCATE STORAGE may not be specified for
Composite Range partitioned object



ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object..

Answer / guest

Cause: User specified ALLOCATE STORAGE clause in ALTER
TABLE/ALTER INDEX statement issued against a
range-partitioned index which is illegal.

Action: Remove the illegal option. If it is desired to add
storage to individual partitions, ALLOCATE STORAGE clause
may be specified with ALTER TABLE/INDEX MODIFY PARTITION
statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12500: stoplist string already exists

1 Answers  


ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

1 Answers  


ORA-13415: invalid or out of scope point specification

1 Answers  


ORA-32009: cannot reset the memory value for instance string from instance string

1 Answers  


RMAN-08154: deleted script: string

1 Answers  






ORA-12672: Database logon failure

1 Answers  


ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 Answers  


NNO-00261: cannot construct configuration checkpoint file name

1 Answers  


TNS-01013: set|show trc_{ } [<value>]: set|show trace parameters of current listener

1 Answers  


ORA-24392: no connection pool to associate server handle

1 Answers  


ORA-25956: join index cannot be created on tables owned by SYS

1 Answers  


ORA-29269: HTTP server error string

1 Answers  






Categories