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

ORA-16025: parameter string contains repeated or conflicting attributes

1 Answers  


IMP-00028: partial import of previous table rolled back: number rows rolled back

1 Answers  


ORA-19210: column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'

1 Answers  


ORA-00077: dump string is not valid

1 Answers  


TNS-01000: spawn [<listener_name>] <spawn_alias> [<(ARGUMENTS='arg0, arg1,...')>]

1 Answers  






PLS-00613: only one item is allowed, when using variables of record type

1 Answers  


RMAN-08124: keep attributes for the datafile/controlfile copy are changed

1 Answers  


ORA-13637: Executing or modifying task string is disallowed until the task is reset to its initial state.

1 Answers  


ORA-02029: missing FILE keyword

1 Answers  


ORA-00221: error on write to controlfile

1 Answers  


ORA-14166: missing INTO keyword

1 Answers  


ORA-25505: the system is not in quiesced state

1 Answers  


Categories