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!

How to remove soft deleted records?

577989Jan 14 2010 — edited Jan 15 2010

Hi everybody,
Are there any ways to remove soft deleted records from LT table?

For instance, table is versioned and database has few workspaces. The user removes some data from LIVe workspace (or from other workspaces). The removed records are marked as deleted in the LT table, but never removed from LT table even the compression is executed on all workspaces.
I found the only way to remove them is to remove all workspaces and savepoints and when run compression. After that it removes all soft deleted records (records that are marked as deleted in LT table).

I have a thousands active records while hundred of thousands are soft deleted, which causes performance degradation.

Any suggestions?

Thanks for any input.

Edited by: dmbond on Jan 14, 2010 7:15 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2010

Added on Jan 14 2010

#database-key-features, #workspace-manager

8 comments

4,439 views