Make sure you don't miss any public synonyms, public db links, or roles.
These will not be exported with a user-level export.
The 20Gig size should be ok for this method (exp/imp). Larger databases
might need to use other methods already posted by others.
--
"Wade Chy" <wchy65_at_yahoo.com> wrote in message
news:4fad73ef.0310011218.64c50c1c_at_posting.google.com...
> Hi All,
> I have been assigned to migrate a 8i database to a new 9i database.
> The current 8i server is on W2K with 1GB memory. The new 9i server is
> on a W2K3 with 6GB memory. There's about 20 GB data in 2 schemas.
> Here's my plan:
>
> 1. Install the Oracle 9.0.2
> 2. Create a new database instance in the 9i server using the DBCA.
> 3. Export the 2 schemas from the 8i server and split the dmp file to
> 2GB files during off hours.
> 4. Ftp the dump files over to the new server during off hours.
> 5. Import the dmp files to the new 9i database.
>
> This new 9i server will be running along the 8i server for some time
> while the applications are tested before promoted to production. So I
> will have some time to monitor and make changes as required in test
> env.
>
> My question is what's the downside to this plan if any? What sort of
> problem I could face during the installation process? What sort of
> problem I could face with VLM(6GB Memory)? I am going through the
> installation guide now and found that 9i support VLM. Your feedback
> and installation / migration experience will be greatly appreciated.
> TIA
>
> Wade Chy
Received on Sat Oct 04 2003 - 03:03:15 CDT
