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
is
> really a nice solution.
>
> Thanks
> Dennis
>
Received on Fri Nov 14 2003 - 07:53:46 CST
