Home » RDBMS Server » Backup & Recovery » Deleting all data of corrupted database
Deleting all data of corrupted database [message #657710] Fri, 18 November 2016 21:39 Go to next message
albayenes
Messages: 4
Registered: November 2016
Junior Member
Hi everyone,

I have a database with corrupted datafile. I cannot query my tables because of datafile corruption. I altered datafiles as offline. So I cannot read or write datafiles. I decided to return my database initial state. I want to delete all my table data and I want to bring back only my tables. Is there any way to adding empty datafile to database and returning database its initial empty state (just I want to bring back my tables etc.) using rman or sql query?

Thanks in advance.
Re: Deleting all data of corrupted database [message #657711 is a reply to message #657710] Fri, 18 November 2016 21:45 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

What is OS name & version?
What is Oracle database version to 4 decimal places?
What RMAN backups do you have?

In the future, do NOT tell us or describe what you think you have; but use SQL & then COPY & PASTE what you do & how Oracle responds.
Re: Deleting all data of corrupted database [message #657715 is a reply to message #657710] Sat, 19 November 2016 00:49 Go to previous message
Michel Cadot
Messages: 65199
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Follow the advice John gave you in your previous topic.
We won't be able to do anything without first following these advice.

[Updated on: Sat, 19 November 2016 00:49]

Report message to a moderator

Previous Topic: creating tables using datafiles
Next Topic: Transport tablespace with Oracle Standard Edition
Goto Forum:
  


Current Time: Mon Nov 20 20:48:43 CST 2017

Total time taken to generate the page: 0.02789 seconds