Oracle Backup

Sandra

I have Oracle 8.1.7 for NT with one database that has many schemas,
one for each project under development.
I need some way to backup each one of those schemas, some of them
should be copied weekly, others need a dayly copy and so on.
Is there any way of doing that besides using export? If there is a
way, please, explain how is it done and how can it be recovered.

Thanks.

Jul 19 '05 #1

Ana C. Dent

Sandra wrote:

I have Oracle 8.1.7 for NT with one database that has many schemas,
one for each project under development.
I need some way to backup each one of those schemas, some of them
should be copied weekly, others need a dayly copy and so on.
Is there any way of doing that besides using export? If there is a
way, please, explain how is it done and how can it be recovered.

Thanks.

What's wrong with using export.
Export is designed to do exactly what you seem to want to do.

Jul 19 '05 #2

kiber

You can use RMAN, export/import, physical copy and online/offline and
WinNT scheduler to schedule.
--
Posted via http://dbforums.com

Jul 19 '05 #3