Copying v8.1.5 NT Database to 10g Win2003 Server?

Hello,

I installed Oracle 10g on Win2003. I created a database with the same name (Say TEST) as a v8.1.5/NT database on another server. I used a similar init<SID>.ora for both databases, though I had to adapt some parameters such as 'compatible', 'log_archive_format', pool sizes etc.. for 10g. (The control files and rollbacks are the same for 10g and 8i).

I created the same tablespaces (With the same sizes and datafiles) and rollback segments (Sorry for those of you who cringe at the words 'rollback segments' and 10g in the same sentence) in 10g as in 8i, with the addition of SYSAUX in 10g.

I also created the same Windows directory structure for Oracle in Win2003 (10g) as in NT (8i), and adapted the necessary env. variables and/or registry parameters. 'listener.ora' and 'tnsnames.ora' have also succesfully been adapted.

Will I be able to do a straight copy of the source 8i files into the target 10g Oracle directory structure, and reset the logs in the target 10g database when opening it?

I realize that an export/import may be more straightforward, but the server hosting the source 8i database may not have the disk space necessary for an export.

Thanks,
SAP BASIS Consultant Received on Mon Nov 29 2004 - 16:36:39 CST