"Peter Laursen" <ptl_at_edbgruppen.dk> wrote in message
news:3e23fa9e$0$264$edfadb0f_at_dread15.news.tele.dk...
>
> "Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message
> news:v27u50s55or2f8_at_corp.supernews.com...
> > alter table <table_name>
> > move
> > storage(initial <desired size>;
> >
> > regards,
> > Peter
This will work if the table is empty, however it looks to me (from the
number that is given for initial extent) that you have issued exp with
COMPRESS=Y which will try to give an initial extent into which the entire
table fits. You don't want this especially if you have tabls with several gb
of data!.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Jan 14 2003 - 06:03:45 CST
