OraFAQ Forum: Server Administration » Database or data Move

Home » RDBMS Server » Server Administration » Database or data Move (Windows 2003 and windows 2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database or data Move [message #324727]

Tue, 03 June 2008 16:00

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...

Report message to a moderator

Re: Database or data Move [message #324730 is a reply to message #324727]

Tue, 03 June 2008 16:07

BlackSwan
Messages: 26766
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?

Report message to a moderator