recover info from table partition with missing offline datafile
759679Mar 12 2010 — edited Mar 13 2010I just restored a backup of a database; when i unzipped the datafiles i found out that one datafile was damaged so in order to startup the database i had to put the datafile offline. The tablespace which the datafile belongs to holds the information of one table partition. Since i don't have archives from the time the datafile was created i know it wont be posible to recover the datafile, what i what is to recover as much rows as posible from the remaining datafiles in the tablespace but when i to export or create table as select from the affected partition y get ORA-00376: file 1624 cannot be read at this time.
is there a way to tell oracle to skip the offline datafile and export the information of the remaining datafiles?
Just to clarify my situation a little more;
iI have a table called PPGA_ACTABOPRE which is partitioned by HASH and has 20 partitions, each partition in a different tablespace and each tablespace has about 8 datafiles. One datafile in the 9th partition is missing and i want is to recover the info from the remaining datafiles but every time i issue a select or a exp or whatever i get ORA-00376.
I try to set the flag to skip corrupted blocks with execute DBMS_REPAIR.SKIP_CORRUPT_BLOCKS('PPGA','PPGA_ACTABOPRE'); and then select the info but it didnt work.
Any suggestions would be appreciated;
Thanks in advance