Home » RDBMS Server » Server Utilities » upgrade to new version(7.3 to 9.2)
upgrade to new version(7.3 to 9.2) [message #74020] Wed, 25 August 2004 10:06 Go to next message
shyam_kk
Messages: 9
Registered: August 2004
Junior Member
i made a export of a database oracle7.3.2(solaris 8).I want to import it into  oracle 9.2.0.1
windows 2000 adv server.Irrespective of os it will work.Correct ?.Whats the prerequistes
to import to new database(9.2.0.1).Wheter i have to create users with tablespaces or users alone.Is
there any of these(users & tablespace) because dmp file contains the definitons of the schmeas
and tablespaces.What shall i do the desupported features in 9.2 that's supporting in 7.3
i will create a empty database with large undo segment( how much big the undo segment).
waiting for ur valuable reply
shyam

Report message to a moderator

Re: upgrade to new version(7.3 to 9.2) [message #74030 is a reply to message #74020] Fri, 27 August 2004 12:47 Go to previous messageGo to next message
Vikas Arya
Messages: 7
Registered: August 2004
Junior Member
Shyam,

You need not create the user or tablespace but, the direcctory structure should exist as you have it in 7.3.2.Files will be created when u try to import.

-Vikas

Report message to a moderator

Re: upgrade to new version(7.3 to 9.2) [message #74035 is a reply to message #74030] Sat, 28 August 2004 07:22 Go to previous message
shyam_kk
Messages: 9
Registered: August 2004
Junior Member
hi vikas
can u explain detaily how this will be acomplish.That means we should create the tablespaces.The datafiles that makes the tablespaces correct

Report message to a moderator

Previous Topic: Loading a column containing newline
Next Topic: ora-01092
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 11:21:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.