Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sjc70.webusenet.com!news.webusenet.com!wn11feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!rwcrnsc52.ops.asp.att.net.POSTED!not-for-mail
From: "John Darrah" <nospam@nospam.net>
Newsgroups: comp.databases.oracle.server
References: <auj0l4$gas$1@news6.svr.pol.co.uk> <ZZsP9.365582$GR5.109524@rwcrnsc51.ops.asp.att.net> <aulrg0$jkd$1@newsg4.svr.pol.co.uk>
Subject: Re: Lost datafile for dataless partition
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <85NQ9.526951$%m4.149488@rwcrnsc52.ops.asp.att.net>
NNTP-Posting-Host: 12.253.104.161
X-Complaints-To: abuse@attbi.com
X-Trace: rwcrnsc52.ops.asp.att.net 1041472964 12.253.104.161 (Thu, 02 Jan 2003 02:02:44 GMT)
NNTP-Posting-Date: Thu, 02 Jan 2003 02:02:44 GMT
Organization: AT&T Broadband
Date: Thu, 02 Jan 2003 02:02:44 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:170957
X-Received-Date: Wed, 01 Jan 2003 19:19:56 MST (news.easynews.com)

CT,

I'm guessing you've already figured out some solution to this since its been
a few days but in the future, you should be able to.
1) offline drop the data file
2) alter table drop partition
3) drop tablespace including contents

I tried this the other day and it worked.

Hope this helps
"CT" <CT@nomail.com> wrote in message
news:aulrg0$jkd$1@newsg4.svr.pol.co.uk...
> Thanks John for the resopnse,
>
> I tried to offline drop the datafile as per the textbooks (for non
> partiitioned tablespaces) and Oracle acknowledged this as good, but the
drop
> of the tablespace yeilded and error (ORA-nnn...can confirm at an eariler
> hour of the morning) tablespace still belonged to an active table (so
> dropping was not an option, and Oracle still recognised the datafile as
> alive and kicking) . You see my deilema?!
>
> No such instance of my problem has surfaced in recent times on this news
> group via metalink or through google search which  gives me an insight as
to
> whether i'm at a point of no return regarding this problem and trying to
do
> something that this version of Oracle doesn't allow, or being dense and
> missing something obvious.
>
> Thanks for the input.
> CT
>
>
>
>
> "John Darrah" <nospam@nospam.net> wrote in message
> news:ZZsP9.365582$GR5.109524@rwcrnsc51.ops.asp.att.net...
> > I don't have access to a DB with the partitioning option installed at
the
> > moment so I apologize in advance for offering up a suggestion that I
> haven't
> > tried.  I think you should be able to offline drop the datafile in
> question
> > and drop the partition.  If that works, you can drop the tablespace.
> > Hope this helps,
> >
> > John
> > "CT" <CT@nomail.com> wrote in message
> > news:auj0l4$gas$1@news6.svr.pol.co.uk...
> > > Oracle 8.0.5, on Tru64.
> > >
> > > I have a partitioned table which has lost (physically deleted) one of
> it's
> > > datafiles for the partitions. The partition in question contains no
> data,
> > so
> > > no data has been lost, how can I recreate/remove this partition given
> the
> > > absence of  any viable physical backups (yes...I know....!) and the
> > absence
> > > of archive logs.
> > >
> > > Oracle doesn't seem to like the deletion of the tablespace (and
> associated
> > > datafile) for this partition because the datafile isn't there for it
to
> > > interrogate and remove contents.
> > >
> > > Is there a way to force the deletion given I knwo the partition has
not
> > been
> > > used, or associate a datafile with this paritions tablespace.
> > >
> > > Thanks
> > > CT
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>