Home » RDBMS Server » Server Administration » Database or data Move (Windows 2003 and windows 2000)
Database or data Move [message #324727] Tue, 03 June 2008 16:00 Go to next message
Knud
Messages: 2
Registered: June 2008
Location: Sweden
Junior Member
Hi folks

Im kinda new to Oracle, have some "limited" experience. Embarassed

My problem a application upgrade required a new server and more......

Today's production is on a old win 2000 with oracle 9
the new so far only "test" environment have
Win 2003 and oracle 10.
Database structure (schema's, tablespaces and so) are identical.
What i need is...

1. Clear the data in the new environment.
2. Move data from old environment to the new.

Is this a good approach ?? or should i just delete database in the new env and create a new and then import ? If so how can i get the create script from the old env ?

(I did some of the work in the new env, but they guy who did most of the Oracle stuff doesn't want to share them Sad and my boss says i have to do this...)

anyway thanks in advance for any help...
Re: Database or data Move [message #324730 is a reply to message #324727] Tue, 03 June 2008 16:07 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>my boss says i have to do this
Nothing is impossible for the person who does not have to actually do it.

Too bad for you that you need to depend upon the kindness of strangers to do your job for you.

How are backups being done on the old system?
Re: Database or data Move [message #324731 is a reply to message #324730] Tue, 03 June 2008 16:20 Go to previous messageGo to next message
Knud
Messages: 2
Registered: June 2008
Location: Sweden
Junior Member
oHH sorry i missed ...

The old system uses oracle agents to backup and windows scheduled exp to dmp file.


Re: Database or data Move [message #324734 is a reply to message #324727] Tue, 03 June 2008 16:35 Go to previous message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
Follow the documented restore procedure, but restore on new system.
Previous Topic: Oracle Database Move to a new Server
Next Topic: how to convert a latin-1 db to utf-8 database.
Goto Forum:
  


Current Time: Fri Dec 02 12:20:10 CST 2016

Total time taken to generate the page: 0.12580 seconds