Help - Search - Members - Calendar
Full Version: ORA-01122
Oracle DBA Forums > Oracle > Oracle Forum
Nav Singh
Guys Need help???

I can't shutdown the database as i get following error......

shutdown immediate;
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....

Cheers,
Nav
SteveC
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.
Nav Singh
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.

Cheers,
Nav
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.