I am new to databases and hence need a help:
I have dropped the tables from my database without taking any kind of backup.
Now i want the data to be recovered in the database(archivelog/noarchivelog mode). How do i do that?
Please suggest me the concept and steps to resolve this issue.
you cannot recover unless you have a backup
however if on 10g or above the table may still be in the recycle bin which you can recover from
I've seen this very same question a few days ago... same wording... home work, isn't it?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
provided the user didn't use PURGE clause.
Originally Posted by davey23uk
Click Here to Expand Forum to Full Width