ORA-55610: Invalid DDL Statement on history-tracked table

You will get this error if you are trying to Truncate or perform the Shrink Space operation on a table that is connected to a Flash Archive

If unless totally necessary to do above operation; you will need to detach the table from the Flashback Archive using below command

ALTER TABLE tablename NO FLASHBACK ARCHIVE;
Advertisements

About Sunil Padmanabhan

An Indian based out of Dubai who started traveling from 2011 and pretty much caught the travel bug. Every year presents itself as an opportunity to visit and explore a new place.

Posted on January 28, 2014, in DB, Oracle, Oracle 11g - Windows. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: