Oracle Database Discussions

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!

Prep for IMPORT

223563Apr 2 2004 — edited Apr 2 2004

Hi:

I'm considering using EXPORT/IMPORT to backup one of my databases. From what I've read (Oacle8i DBA Handbook), this approach is clled a "Logical Backup". The export looks fairly straight forward. But, what do I need to do to prepare for the import?

If the corrupt DB still has all it's tablespaces, table, indexes... etc..., should I drop/delete all of them before doing the Import? Does Import do this for me automagically? Is there a "drop schema" that I can use? Does Export export the tablespace info as well, and, will import recreaet the tablespaces? Same question for Datafiles?

Thanks in Advance for any help

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2004

Added on Apr 2 2004

#general-database-discussions

5 comments

163 views