Marc G. Fournier wrote:
>
> I have someone that is asking if you can recover some tablespaces in a
> database, but leave the others online ... apparently its a feature of
> tablespaces under Oracle ... I could see it for schemas, but sounds like
> it could cause problems depeending on how you are using tablespaces ...
You can not. The tablespace is not an independent entity. I doubt we
would ever suppor that. I suppose if the entire database was in a
specific schema you could recover that but you would have to adjust the
shared system tables perhaps.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
