Jul 29 2008, 01:10 AM
Guys Need help???
I can't shutdown the database as i get following error......
ORA-01122: database file 7 failed verification check
ORA-01110: data file 7: '/A33/DEV/oradata/E1DEV/dd7333i01.dbf'
ORA-01208: data file is an old version - not accessing current version
File contains just the indexes which i can rebuid anytime....What 'd be the best to fix this issue....Ideally i want to drop this datafile or even tablespace and create indexes using new file.in new tablespace...
Thanks in Advance....
Jul 29 2008, 01:18 AM
The best issue to fix is to find out how/why one of your files got hosed, and then to prevent that from happening again. Someone without adult supervision was playing in the database.
Offline drop the tablespace including contents and datafiles.
Jul 29 2008, 01:32 AM
Thanks for Quick response.....
I am not oracle DBA but do now some basic stuff.....Do i need to shutdown database then mount and then drop objects and then open database again...Is there any other option.
Jul 29 2008, 02:14 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here