Re: When to Create Database vs Schema only !!!

Torfrid Leek (torfridl_at_ulrik.uio.no) wrote:
>Is it possible to use tablespace recovery to recover from user errors?
>I mean, if I have the applications in distinct tablespaces and somebody
>accidentally destroys some of their application's tables, can I do a
>recover until.... on that tablespace and set it back to a point in time
>before the unwanted change occurred, while keeping the other tablespaces
>uptodate? Or do we need to do exports to achieve this functionality?
>Regards, Torfrid

Assuming that you have a combination of media backups and logs (archived and/or online) representing everything up to the point in time to which you want to recover, yes. You can only do this to an entire tablespace (not selected tables) and you will lose all updates (valid or not) that have occurred after the point in time. If the tablespace contains tables that you do not want reset, you can export them prior to recovery and import after.

/b

--
Bill Manry  -  Mainframe and Integration Technologies  -  Oracle Corporation
Standard disclaimer applies.