Re: ORA-1251

From: zhuchao <chaos_at_cattsoft.com>
Date: Wed, 13 Sep 2000 9:25:16 +0800
Message-Id: <10617.116781@fatcity.com>

sfcawley=A3=AC

      i am a beginner and my suggestion maybe can't work? =09can 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?
=09if 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.

=D4=DA 00-9-12 =C9=CF=CE=E7 09:34:00 =C4=FA=D0=B4=B5=C0=A3=BA
>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
>
>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......

                    =D6=C2

=C0=F1=A3=A1

..................................
..................................
            zhuchao
          chaos_at_cattsoft.com
___________________________________

=B6=AA=B5=F4=C4=E3=B5=C4outlook,=CA=D4=D2=BB=CF=C2FoxMail=B0=C9=A3=A1

.................................
=D7=F6=D7=D4=BA=C0=B4=F3=CC=C6=C8=CB=A3=AC....................

Received on Tue Sep 12 2000 - 20:25:16 CDT