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

Clive Bostock (clive_at_shimmer.demon.co.uk) wrote: [regarding my earlier remark:

 >>The lowest level of _media_ recovery is the tablespace.  Media
 >>recovery works in conjunction with Oracle redo logging to
 >>allow recovery of a tablespace to the latest committed
 >>transaction or to a specific point in time. ]
 

>Surely this is not strictly true. Oracle is clever enough to recover a
>partly damaged (i.e. one or more damaged files of a multi-file
>tablespace) tablespace. Simply by recovering the lost/damaged file(s)
>and rolling forward from the archived logs.

Yes, I really misstated that. More appropriate to say that the tablespace is the lowest logical database structure that can utilize media backup and recovery.

Thanks for speaking up!

/b

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