Re: Upgrading a Windows 2000 server box with Oracle 8i to Windows 2003 Server with 9i

"Paul Drake" <drak0nian_at_yahoo.com> wrote in message news:1ac7c7b3.0309171534.1936cf5b_at_posting.google.com... <snip>
> Are you sure that you want to migrate dictionary managed tablespaces
> to locally managed tablespaces (e.g. SYSTEM) - which you would be
> doing if you migrate your existing databases.

I'm not sure that this is correct. As I understand it the migration will leave all tablespaces as they were unless you specifically chose to migrate them using the supplied DBMS_SPACE_ADMIN PL/SQLpackage. Nevertheless you certainly you can have dictionary managed tablespaces in a 9.2 db if you so desire.

> I have not compared the
> difference between a cleanly created LMT system tablespace, and a
> dictionary managed tablespace that was migrated to LMT. The databases
> that I have been working with are relatively small (under 2 GB of
> data) so exp/imp has been a good route.
> Import of 1.6 GB of dump files took less than 1 hour (build indexes
> nologging afterwards) on decent hardware (PIII 900 MHz, not the latest
> greatest 3 GHz Xeons).

Connor has a brief intro at http://www.oracledba.co.uk/ under administration, though I think I have seen some docs somewhere suggesting that the TABLESPACE_MIGRATE_TO_LOCAL package only really does half the necessary work.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK