Re: reorg of a tablespace

Peter Kesch (kesch_at_kappco.kapp-coburg.de) wrote:
> hi oracle guruus,
 

> i'm running in a problem, i can't solve by myself.
> here's the subject:
 

> we've created a tablespace with a datafile of 100Megs.
> after a year we've seen now, that 20Megs will be enough.
> (please no flames, we've had our reasons to size it this space, but they've
> changed)
> well, now we want to reduce the size. (need the diskspace)
> we've tried a full database backup, recreated the database with the new sized
> datafiles and tried to import it again. but then we've got an error with a
> different tablespace; the size we created it was even bigger than the original.
> the error was : unable to allocate extent .......
 

> now my question:
> 1. what is the best way to reduce the size of a datafile in a tablespace???
 

> 2. why did i got the errors on a tablespace we sized up??
 

> any help is welcome
 

> thanks Peter
 

> --
> Peter Kesch Kapp & Co email:kesch_at_kapp-coburg.de
> phone:+49 9561 866376 Callenberger Strasse 52-58
> fax: +49 9561 866103 96450 Coburg, Germany

    When you make an export and import, the import try to create the     tables with the same inital that each table has defined in its     storage clause, even if they are empty.

    So, I think you must create the tables with less initial before     doing the import in order to avoid the import make "create table".     Using this way you will be able to control the size of the tables.

    Remember to do the import with :

     IGNORE ERRORS FOR EXISTING OBJECTS = Y      I hope this helps you.

     Regards. Received on Mon Jun 06 1994 - 09:21:46 CEST