Database Administration (MOSC)

MOSC Banner

Cannot drop table after start dropping unused columns checkpoint

edited August 2020 in Database Administration (MOSC) 6 commentsAnswered ✓

Hello

with Oracle 19c, and a large table with 600 columns and

I get the message below after tried DROP TABLE XXX;  :

ORA-00604: une erreur s'est produite au niveau SQL récursif 1

ORA-12986: colonnes partiellement supprimées. Exécuter la commande ALTER TABLE DROP COLUMNS CONTINUE

before that, 4 columns was set unused with ALTER TABLE XXX SET UNUSED (CCC1,CCC2,CCC3,CCC4); and dropping columns was started with ALTER TABLE XXX DROP UNUSED COLUMNS CHECPOINT 500;

this statement was stopped with CTRL+C because this was too long (more than 24h)

at this point, dropping this table seems to be impossible, I just could do ALTER TABLE XXX DROP UNUSED COLUMNS CONTINUE CHECKPOINT 10000;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center