Re: Oracle 10g & tablespaces

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 25 May 2005 15:18:44 +0200
Message-ID: <d71tmt$nr8$1@news1.zwoll1.ov.home.nl>

Matthias Hoys wrote:
> - downtime : we can do it in a week-end
So, imp/exp is feasible?
Makes you getting rid of all 8i stuff, start with a clean install. Watch out for SYS grants - not exported!

> - no SAP
> - space issues : we currently have a lot of fragmentation because of the
> large differences between extent sizes

No you don't: you did not have more than 1000 extents.

> - total size of full export dump for largest db is around 50GB
Now, it's multiple databases?

> - no LOB objects ...

So, no (re)naming issues there

-- 
Regards,
Frank van Bortel

Received on Wed May 25 2005 - 08:18:44 CDT