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 -> REPOST: Re: tablespace deleted..............pl help me

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

From: James Williams <willjamu_at_mindspring.com>
Date: Thu, 24 Jan 2002 13:10:31 GMT
Message-ID: <9$--$%%%%---__-$-$@news.noc.cabal.int>


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;

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 07:10:31 CST

Original text of this message

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