Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to imp database for a recover

592815May 7 2009 — edited May 7 2009

Hi Experts,
We have a database as oracle10G R4 in 32 bit window.
I makk a full database exp as a backup.
At the present, i find some data file is missing in user dev tablespace.

My question, we do not have a schema or tablespace exp dump file.

For exiting DB, Do we need to drop all tablesapce (include sys tbs) and recreate tablespaces for imp full database recover?

Thanks for help!

JIM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2009

Added on May 7 2009

#database-key-features, #export-import-sql-loader-external-tables

3 comments

1,412 views