ORA-14065: ALLOCATE STORAGE may not be specified for a
partitioned table



ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table..

Answer / guest

Cause: User specified ALLOCATE STORAGE clause in ALTER TABLE
statement issued against a partitioned table 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 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

PCC-00033: Missing operand for option "string"

1 Answers  


PLS-00252: reference to the wrong copy of package STANDARD

1 Answers  


ORA-19572: cannot process file string, file is being being resized

1 Answers  


ORA-29872: parameters clause cannot be combined with the specified options

1 Answers  


ORA-38451: index is in an inconsistent state

1 Answers  






ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

1 Answers  


RMAN-10040: asynchronous support not detected, RMAN will run synchronously

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


ORA-13221: unknown geometry type in the geometry object

1 Answers  


ORA-07576: sspexst: $GETJPIW failure on process ID string

1 Answers  


TNS-12562: TNS:bad global handle

1 Answers  


Categories