[mmshekiba]

Hi,
I have a windows 2000 server which has oracle 9.0 and a database which its dump is 20G.I'd like to export the whole database to another server which is windows 2003 and oracle 9.2. unfortunately I couldn't fine oracle 9.0 so I was forced to use oracle 9.2.
I did a full export by executing this command:
exp system/manager file=f:\exp.dmp log=my_dump.log full=y

while importing to server 2003 and oracle 9.2 I got some bad errors:

1) The block size in oracle 9.0 is 4096 but the block size in oracle 9.2 is 8192 and many errors were about this.

2) The path of tablespaces and .. in oracle 9.0 is something like d:\oracle\ora90\... and this path is in dump file from export.but the oracle path in 9.2 is different .somthing like d:\oracle\ora92\.. and it causes many errors too.

I searched a lot.even I wanted to downgrade oracle 9.2 to 9.0 but I couldn't.

Could you please help me?how can I import that dump to my oracle 9.2 .I'm new to oracle and I don't have enough knowledge on doing this.Do I need to downgrade to 9.0?
Thank you

[mmshekiba]

Hi,
I have a windows 2000 server which has oracle 9.0 and a database which its dump is 20G.I'd like to export the whole database to another server which is windows 2003 and oracle 9.2. unfortunately I couldn't find oracle 9.0 so I was forced to use oracle 9.2.
I did a full export by executing this command:
exp system/manager file=f:\exp.dmp log=my_dump.log full=y

while importing to server 2003 and oracle 9.2 I got some bad errors:

1) The block size in oracle 9.0 is 4096 but the block size in oracle 9.2 is 8192 and many errors were about this.

2) The path of tablespaces and .. in oracle 9.0 is something like d:\oracle\ora90\... and this path is in dump file from export.but the oracle path in 9.2 is different .somthing like d:\oracle\ora92\.. and it causes many errors too.

I searched a lot.even I wanted to downgrade oracle 9.2 to 9.0 but I couldn't.

Could you please help me?how can I import that dump to my oracle 9.2 .I'm new to oracle and I don't have enough knowledge on doing this.Do I need to downgrade to 9.0?
Thank you

[amitpatel66]

Duplicate Threads merged for better management of the forum

MODERATOR