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_at_nomail.com> wrote in message
news:auj0l4$gas$1_at_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
>
>
>
>
>
Received on Sat Dec 28 2002 - 20:20:41 CST
