Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace without its .dbf file

Re: tablespace without its .dbf file

From: Nanard <bsegonnes_at_free.fr>
Date: 21 Jun 2006 06:29:23 -0700
Message-ID: <1150896563.504688.24380@g10g2000cwb.googlegroups.com>


> I assume you don't have a backup. You could export all the data except the
> contents of this tablespace and then rebuild the instance. You should call
> support.

Thanks, but there's nothing easier ? The instance is created/used by a big application we use/need, I have only created a TBS/user for our needs. I do care about the instance but not about the tablespace.

Is it not possible to 'only' remove the tablespace from the instance ? Received on Wed Jun 21 2006 - 08:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US