Re: Resize Datafile

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Fri, 08 Feb 2002 02:53:44 GMT
Message-ID: <Y4H88.1692$Uc7.984890476@newssvr21.news.prodigy.com>

Gaetan,

If the ALTER DATABASE DATAFILE ... RESIZE does not work because there of fragmentation, then find out which objects reside in the tablespace which has the datafile. If you place your objects right then export the objects from this tablespace, drop the tablespace and recreate it with smaller datafiles. After that import the objects back.

Of course that depends on your setup and size of the database.

If using Oracle 8i you can also move the objects to temporary tablespace then recreate it and move them back.

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

Join the new Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

"Gaetan Poitras" <poitrasg_at_crcsogema.com> wrote in message news:3ebc2be2.0202070625.2fbface4_at_posting.google.com...
> Hello.
> I am looking to find a solution to reduce the size of a datafile. Is
> it possible and how..?
> Thank you
Received on Thu Feb 07 2002 - 20:53:44 CST