Hi all

I have a Question about Backups:

At the moment we are backuping the whole Tablespaces, if the systems crashes, we can reload the whole stuff (hopefully it never will happen ....).:eek:

As far as I know, its not possible to reload just one Table from the Backup. Is this really true?
Has anyone got a Solution, that allows to reload specific Tables?

Our Enviroment is BaaN 4c4 and Oracle 8.1.7 running on Solaris 7.
The Backup-Software is Networker from Legator.

Have a nice Day

No, for recovering only one table you must recover the database in another system/instance and then export the table from that system into your current one.

That's what I was affraid of.
Wasn't it nice in the older times with Triton, T-Base and HP-UX:rolleyes: , were you coul'd reload specific Tables directly from the Tape?

well thanks a lot for the quick response!
Regards
Phil

What a lot of customers do as well besides making a backup is create an export of the db on a regular basis.

It takes time, uses a lot of disk space but it gives you the possibility to import selected tables.

Rgrds,
Han