Database scripts !!!

[Striker99]

All,

I am relatively new to Oracle and i am using Oracle 7.3.4

I have a database which needs to be migrated to the new hardware environment. I need to do two things
1) Create the database on the new environments which is almost similar to the existing one. When i say almost similar, few things needs to be changed, like tablespace and storage parameters. Is there a way to generate to scripts to create the database from the existing database ?
2) Once i have migrate DATA to new enviroment, i need to compare the data on the two database and prove that it is the same ? Is there any tool/scripts to do so ?

Any inputs on the above issues is welcome.

Thanks in advance,
striker99

 

[alexhu]

If you're using the same OS and disk layout, then use your backup tapes. It will be very much faster than recreating and importing.

What aspects of the tablespace parameters do you want to change ?

Alex

 

[Striker99]

Thanks of your reply.

I do not want to restore from the back up tape. The idea is to create the database similar to the existing one and then change the parameters to reflect the changes done in the benchmark( performance test) and then load the data at the later stage.

thanks,
striker99

 

[JamesGordon]

If you have Oracle Designer you could reverse engineer the database into Designer and it can then create the scripts for you. If you haven't got it then you will probably have to do something like "alter system backup controlfile to 'filename';".
This would give you the basic structure of the database. You could then copy the init.ora file and make changes to it i.e. db_block_size etc.
Another way, sorry I'm thinking whilst I write, is to use the database configuration assistant and it can create the scripts for you, which you could then manipulate and re-run on any system you want, using the same OS.

 

[alexhu]

Try this

http://www.orafaq.com/msgboard/general/messages/836.htm

Alex

 

[alexhu]

Try here

http://www.orafaq.com/msgboard/general/messages/836.htm

Alex