Re: reorg of a tablespace

In article <CqpLBy.EB0_at_kapp-coburg.de>, kesch_at_kappco.kapp-coburg.de (Peter Kesch) says:
>we've created a tablespace with a datafile of 100Megs.
>well, now we want to reduce the size. (need the diskspace)
>the error was : unable to allocate extent .......

ok, the problem is that in a 100 Meg tablespace your table probably had been preallocated to use nearly that much space. In exporting your table, there is therefore a create table statement with a huge initial extent size, which no longer fits into your reduced tablespace.

the solution:
1. run <exp x/y indexfiles=blah.sql>
2. edit blah.sql to change the initial extent value for this table,

   and remove all the other junk in the file

3. create your tablespace
4. run <sqlplus x/y _at_blah.sql>
5. import your data.

the trick is to create the table first, then import. the redundant create will be ignored by imp. regards,

--
Dave Mausner, Senior Consultant, Braun Technology Group, Chicago.