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

"Bonjour" from Paris,

This solution is the best solution if the database is in noarchive mode ('archive log list' in svrmgrl prompt connected internal).

The syntax in order to drop the tablespace is 'drop tablespace ... including contents' in order to
delete all informations of objects.

If you are in archive mode you can use the solution in the 29430.1 note on metalink in the Oracle Support web server. You will restore the datafile without a backup !!! Magic !

Do not try first to manipulate the controlfiles. The solution to modify the controlfiles has to be the 'last manipulation'.

"Au revoir" from Paris
Hieraklion

James Williams wrote:

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

• WAS CANCELLED BY =======: From: Hieraklion <hieraklion_at_spray.fr> Control: cancel <3C500B4D.40907_at_spray.fr> Subject: cmsg cancel <3C500B4D.40907_at_spray.fr> Date: Mon, 28 Jan 2002 03:12:05 GMT Message-ID: <cancel.3C500B4D.40907_at_spray.fr> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!news0.de.colt.net!newsfeed.r-kom.de!newsfeed.freenet.de!peer.news.opaltelecom.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724710

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:25:33 CST