Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BeginDDL is failing with no data found ORA-01403

954597Aug 8 2012 — edited Aug 22 2012

It appears to us that running the AlterVersionedTable command to drop an index has caused an issue for one of our tables that is versioned.

begin
dbms_wm.AlterVersionedTable(
table_name=>'PAC_PMD.CURRENT_DMS',
alter_option=>'DDL',
parameter_options=>'ddl=drop index PAC_PMD.CURRENT_DMS_UK1, force=true', ignore_last_error=>true);
end;

After running this command and then trying to execute BeginDLL we are getting the error ORA-01403 – No Data Found.

Also the state of the table in all_wm_versioned_tables is set to VERSIONED.

Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2012

Added on Aug 8 2012

#database-key-features, #workspace-manager

11 comments

5,550 views