Re: Deleting obsolete datafiles

To me this is much more easy, as there is no extent in the datafile already, so I set it to the smallest possible size, which was 16K in this example. So there is not enough space for oracle to create an extent in it and therefore it is kind of unusable.

Jonathan Lewis wrote:
> If you are using locally managed tablespaces,
> this probably won't quite work. When I tested it
> (some time ago) the smallest I could get a file
> to was 64K plus one extent - which meant it
> could always up being used for data - but that
> could be a lot better than the alternatives.
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
> ____Belgium__November (EOUG event - "Troubleshooting")
> ____UK_______December (UKOUG conference - "CBO")
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK___November
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> "Dennis Bieling" <dennis.bieling_at_epigenomics.com> wrote in message
> news:bp2klp$67b$1_at_broglie.epigenomics.epi...
>

>>Hi !
>>
>>Sorry, I really forgot to mention the version. I am using
>>9iR2. The idea with resizing the obsolete datafile to 1 block size

>>really a nice solution.
>>
>>Thanks
>>Dennis