Database Creation - Suggessions ?

[Striker99]

All,

I am using Oracle7.3.4 and it is running on a production system. I have to migrate this to a new hardware environment along with some database structure changes. How do i accomplish this task ?
1) Create the database from scratch ( from the initial scripts ) and apply any changes made. There may not be a log of all changes. If i do follow this path, there might be some gaps.
2) Take a dump of the database objects ( am not sure how i do this) and then edit the dump and include the changes i want to make and then import this file. This should eventually create the new database with no data and all the required changes. I HAVE LITTLE OR NO IDEA HOW I DO THIS.
3) is there a better way of doing this. May be some tool/scripts which reads the running instance and creates the scripts for me and all i have to do is, to edit this scripts with the changes i want to make ?

Any suggessions on this is welcome.

Thanks in advance,
striker99

 

[harris79]

I would do a combination of options 1 and 2.

On the new hardware I would create the new database from your original scripts.
I would then use Oracle Storage Manager to compare the tablespace sizes against the old version. This is to make sure that the tablespaces haven't been massively increased since the original database build.

I would then export (as sys) the whole of the old database, ftp this over onto the new machine and then import it.

Depending on what changes you want to make, I would make them on the new side only, this ensures that the original data is unchanged.

Steve