
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 ...



----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Thu, 9 Sep 2004 17:05:53 -0300 (ADT)
"Marc G. Fournier" <scrappy@hub.org>
tablespace question ... pg vs oracle
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, Pennsylvania 19073

Fri, 10 Sep 2004 18:19:01 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: tablespace question ... pg vs oracle