Home » RDBMS Server » Server Administration » Database 9i to 10g (server 2003 )
Database 9i to 10g [message #569073] Fri, 19 October 2012 06:51 Go to next message
deep44
Messages: 2
Registered: October 2012
Location: Rajkot
Junior Member

Dear sir

last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
Re: Database 9i to 10g [message #569077 is a reply to message #569073] Fri, 19 October 2012 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i want to connect 9i to 10g with same database and user .


What does this mean?
With a database with same name? Use dbca and create a database with same name?
With the same account? When the database is created then use CREATE USER to create the account you want.

See:
Database 2 Day DBA
Oracle DBA Lite

Regards
Michel
Re: Database 9i to 10g [message #569079 is a reply to message #569077] Fri, 19 October 2012 07:21 Go to previous messageGo to next message
deep44
Messages: 2
Registered: October 2012
Location: Rajkot
Junior Member

i install oracle 9i and 10g in different windows 2003 server , now i want to connect or import all data 9i to 10g in second server
Re: Database 9i to 10g [message #569081 is a reply to message #569079] Fri, 19 October 2012 07:40 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ok, do it. What is the problem?

Regards
Michel
Previous Topic: patch install
Next Topic: impact on table of partition truncate/delete
Goto Forum:
  


Current Time: Thu Mar 28 05:01:14 CDT 2024