ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option



ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option..

Answer / guest

Cause: Name of the partition to be truncated may be followed
by DROP STORAGE or REUSE STORAGE

Action: Ensure that no options besides DROP STORAGE or REUSE
STORAGE are specified with ALTER TABLE TRUNCATE PARTITION

Please add more information about this Error

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06094: datafile string must be restored

1 Answers  


ORA-06919: CMX: error during write request (unknown event)

1 Answers  


RMAN-06197: Total System Global Area string bytes

1 Answers  


ORA-37106: (XSVPART06) Invalid partition name number.

1 Answers  


ORA-24199: message store is overflow

1 Answers  






ORA-09316: szrpc: unable to verify password for role

1 Answers  


ORA-00485: DIAG process terminated with error string

1 Answers  


KUP-04060: field string referenced by lobfile column string not found

1 Answers  


LFI-01519: llseek() failed(OSD return value = string) in string.

1 Answers  


ORA-00445: background process "string" did not start after string seconds

1 Answers  


ORA-16587: Ambiguous object specified to Data Guard broker

1 Answers  


ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


Categories