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!

Script Backup / Restore of a user Schema

659873Sep 16 2008 — edited Sep 17 2008

Hi,

I know I should read documentation for such a basic task. I am new to Oracle and is currently quite overwhelmed by the size of Oracle documentation.

Using Oracle 9i R2 on Windows Server 2003. I would like to make a full backup the DB on file (stored on local hard drive) and possibly to restore it later, either on the same machine/same user or on another server/different user.

Ideally, I would prefer to proceed the backup / restore operations via SQL scripts. Can you please guide me through the basic steps of good practice for backup and restore. Next, I will look further into the documentation to complete the task.

Thank you very much in advance for any help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 16 2008

#general-database-discussions

5 comments

1,100 views