OraFAQ Forum: Server Administration » Migrating from Oracle 8i to 10g

Home » RDBMS Server » Server Administration » Migrating from Oracle 8i to 10g

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

Migrating from Oracle 8i to 10g [message #129912]

Wed, 27 July 2005 05:11

corus
Messages: 12
Registered: July 2005
Location: Process Control

Junior Member

Hi there,

I currently have got a system with Oracle 8i on it which is fully operational.

I will be having a new system with Oracle 10g installed on it.

Now my question is; how should I go on about sending all my database information (tables etc..) from the Oracle 8i machine onto the new machine with Oracle 10g on it?

Any help would be greatly appreciated.

Thanks,

Michael

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #129931 is a reply to message #129912]

Wed, 27 July 2005 06:12

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Even i wants to know the solution.

Good thing to learn.

regards,
tarun

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #129947 is a reply to message #129912]

Wed, 27 July 2005 07:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Depends on how complex the data is.
If it is just simple regular stored procedures / data
a regular export and import will do ( seperately look into your code). If the volume of data is very large, export / import is not a very good solution.
else
go through the upgrade path ( manually) or dbua
the documentation should help you.
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10763/toc.htm

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #132469 is a reply to message #129947]

Fri, 12 August 2005 23:56

ishanparinda
Messages: 3
Registered: August 2005
Location: Colombo

Junior Member

My problem is "svrmgr" is no longer working with 10g. So I got a dump file exported from Oracle 8.1.7 and needs to be impoted to 10g. Can u tell me how to do this.

As u said if the data volume is very high, what would u recommend

Cheers
Parinda

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #132490 is a reply to message #132469]

Sat, 13 August 2005 05:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

svrmgrl is long depreciated.
use sqlplus.
Sys/pasword@databaseconnectstring as sysdba.
svrmgrl/sqlplus has nothing to do with export/import.
use lower version of import (8i) to import into 10g.

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #132623 is a reply to message #132490]

Mon, 15 August 2005 05:21

ishanparinda
Messages: 3
Registered: August 2005
Location: Colombo

Junior Member

I tried with sqlplus in command mode. I connected as sysdba and gave the following command

SQL> imp file=c:\BK12-AUG-05.DMP fromuser=russel toser=kate grants=y

it gives an error:

SP2-0734: unknown command beginning "imp file=c..." - rest of line ignored.

Can u help me on this regard

Cheers
Parinda

Report message to a moderator

Re: Migrating from Oracle 8i to 10g [message #132627 is a reply to message #132623]

Mon, 15 August 2005 06:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

imp/exp are not sql*plus commands.
execute it from the OS command line / dos prompt

Report message to a moderator

Previous Topic:	index_stats not populated
Next Topic:	Anyone work with EMC SRDF?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 14:19:13 CST 2025