Re: ORA-1251

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 13 Sep 2000 08:12:14 -0400
Message-Id: <10618.116819@fatcity.com>

How about restoring them from a backup and doing datafile recovery? ROR
>>> chaos_at_cattsoft.com 09/12/00 10:25PM >>>
sfcawley=20

      i am a beginner and my suggestion maybe can't work?
	can you create the files with the same path,filename,and size of =

as the deleted files in your tablespace and then start oracle,use drop to = delete it logically and then delete it under your os?

        if this doesn't work,try to create the datafiles under another = oracle instance and copy them to the same path,filename,and size of as = the deleted files.maybe this will work?

    hope it works.

  00-9-12 09:34:00 =20
>Ok, so today has not started out right....
>
>I deleted the tablespace files from the filesystem before I dropped them =
in
>Oracle. The current problem is that I need to 'drop' them from the =
system.
>How can I do this?
>
>SC
>
>--
>Author: sfcawley
> INET: sfcawley_at_interaccess.com=20
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

      good luck!
      bye......

                    =20

 =20

..................................
..................................
            zhuchao
          chaos_at_cattsoft.com=20
___________________________________

    outlook, FoxMail =20

.................................
       ....................
____________________________________

--
Author: zhuchao
  INET: chaos_at_cattsoft.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Sep 13 2000 - 07:12:14 CDT