Oracle Database Discussions

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 corrupt an Oracle 10g Database to test repair

4joey1Oct 31 2010 — edited Nov 1 2010

Hallo!I am an Oracle newbie studying for Oracle 10g Database OCP.

In the topic dealing with Database corruption, I have studied several methods of handling database corruption e.g. using dbverify utility, analyze command, dbms_repair package.

Unfortunately for me, all my entire database has integrity thus I cannot test the tools above to assess and experience their efficacy. I need to corrupt a few datafiles, tables, indexes to test these tools.

Please give me tips (in terms of commands) on how I can corrupt a datafile,table and an index.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2010

Added on Oct 31 2010

#11g, #general-database-discussions

4 comments

1,473 views