ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned,
non-clustered table



ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table..

Answer / guest

Cause: The table in the ALTER TABLE EXCHANGE SUBPARTITION
operation is either clustered or partitioned

Action: Ensure that the table with which the subpartition is
being exchanged for is not partitioned or clustered.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26695: error on call to string: return code string

1 Answers  


ORA-01159: file is not from same database as previous files - wrong database id

1 Answers  


ORA-15177: cannot operate on system aliases

1 Answers  


QSM-01035: a row level security policy exists on this table

1 Answers  


NNL-00563: timed_query [<timestamp>] : query all objects in the Names server's cache

1 Answers  






ORA-22813: operand value exceeds system limits

1 Answers  


NZE-29012: Bad key argument length when using SSL 2.0

1 Answers  


RMAN-06550: clone database not mounted and db_name not set in init.ora

1 Answers  


ORA-09310: sclgt: error freeing latch

1 Answers  


ORA-33282: (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.

1 Answers  


ORA-23470: invalid status

1 Answers  


ORA-14253: table is not partitioned by Composite Range method

1 Answers  


Categories