RE: Dropping Tablespaces - All Nighter

Steve,

The problems I would like to gid rid of are :

1. Incorrectly sized and placed datafiles. I'm faced with tablespaces a mere 300Mb large with 3 datafiles scattered around. This creates plenty of free space, but no big chunk for big tables ...
2. Objects created in tablespaces not assigned for the owner of the object
3. Automatically resizing tables created with abnormal small initial extent and rapidly growing ...

Though I would love the challenge of rebuilding the entire database, the new DBA that I am, I wouldn't really know how to achieve all results listed above and my bosses aren't creating enough window for me to do it. The DB can only be stopped at night ....

> -----Original Message-----
> From: Steve Adams [SMTP:steve.adams_at_ixora.com.au]
> Sent: Monday, July 31, 2000 7:23 PM
> To: ORACLE-L_at_fatcity.com; Kirsten.deWeerd_at_oranjewoud.nl
> Subject: RE: Dropping Tablespaces - All Nighter
>
> Hi Kirsten,
>
> If the problem is large numbers of extents in some segments,
> then it may be quicker to take a full database export and rebuild the
> entire database.
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
Received on Mon Jul 31 2000 - 14:56:56 CDT