Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-14006 Invalid Partition Name on alter table...truncate partition

ORA-14006 Invalid Partition Name on alter table...truncate partition

From: Mohan, Ross <RMohan_at_arbinet.com>
Date: Fri, 21 Jan 2005 23:11:32 -0000
Message-ID: <CC74E7E10A8A054798B6611BD1FEF4D30625D7B1@vamail01.thexchange.com>


It's got to be something obvious, which would make this an embarassingly naive question, but, here goes.=20

I've got a table "tab" and a partition "part"

i do alter table tab truncate partition (part);

i get, repeatedly, ORA-14006, invalid partition name

I am logged in as the schema owner, i have tried every (well, a lot) permutation of pre/post parenthetical spacing,=20 capitalization, i've tried pulling the partititon name using dynamic SQL to account for hidden control chars, there are no visitors in v$transaction, redo is quiescent, the dba_TAB_PARtitions tables shows the partitions as named, and = dbms_space_admin.tablespace_verify
on the relevant tspaces is OK ( "completed succesfully" )=20

I've opened a tar, but...this should be easy, and I am=20 plumb out of ideas.=20

Oh, yea, forgot to mention. If we don't get this solved in the next coupla hours, we've got a major failed migration on our hands.=20

Any help really welcome.=20

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 21 2005 - 18:21:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US