when i am doing dropped table reccovery
step1- the tablespace should be in recovery mode is it rite
step2 - the database should be in archivelog mode is it rite
step-3 - identify the dropped table and get it's DDL and note the dropped table id.
step4 - now restore the appropriate tablespace in the which the table is dropped
step5 - rollforward the database
step6 - now create the dropped table by using the ddl generated at LIST HISTORY COMMAND
step7- now import the data into the newly re-created table from the NODE0000 folder which contains the export file
if i done the above mentioned steps i got an error
i.e
SQL3030C An I/O error (reason = "sqlofopn -2029060079") occurred while opening the input file
SQL3333C THE FILE OR DIRECTORY DOES NOT EXIST.
SQL3110N THE UTILITY HAS COMPLETED PROCESSING. "0" ROWS WERE READ FROM THE INPUT FILE.
PLEASE SEND ME THE SOLUTION FOR ABOVE MENTIONED ERROR
step1- the tablespace should be in recovery mode is it rite
step2 - the database should be in archivelog mode is it rite
step-3 - identify the dropped table and get it's DDL and note the dropped table id.
step4 - now restore the appropriate tablespace in the which the table is dropped
step5 - rollforward the database
step6 - now create the dropped table by using the ddl generated at LIST HISTORY COMMAND
step7- now import the data into the newly re-created table from the NODE0000 folder which contains the export file
if i done the above mentioned steps i got an error
i.e
SQL3030C An I/O error (reason = "sqlofopn -2029060079") occurred while opening the input file
SQL3333C THE FILE OR DIRECTORY DOES NOT EXIST.
SQL3110N THE UTILITY HAS COMPLETED PROCESSING. "0" ROWS WERE READ FROM THE INPUT FILE.
PLEASE SEND ME THE SOLUTION FOR ABOVE MENTIONED ERROR