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 deleted..............pl help me

Re: tablespace deleted..............pl help me

From: James Williams <willjamu_at_mindspring.com>
Date: Thu, 24 Jan 2002 13:10:31 GMT
Message-ID: <3c5006e8.655555@nntp.mindspring.com>


At the command line

go to svrmgrl

connect internal

shutdown abort

startup mount

alter database datafile 'path/file' offline drop;

alter database open;

select name,status from v$datafile and note;

drop tablespace xxxxx; Received on Thu Jan 24 2002 - 07:10:31 CST

Original text of this message

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