OraFAQ Forum: Server Utilities » Oracle version (merged 3 threads)

Home » RDBMS Server » Server Utilities » Oracle version (merged 3 threads)

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

Oracle version (merged 3 threads) [message #139971]

Fri, 30 September 2005 06:12

Avra
Messages: 65
Registered: July 2004

Member

Hi,

I have a Oracle exported .dmp file. Is it possible to know from that file that from which version of Oracle (Oracle 8 or 8i or 9i) the dump file has been generated??

Thanks in advance...

Avra

Report message to a moderator

Oracle Version [message #139974 is a reply to message #139971]

Fri, 30 September 2005 06:23

Avra
Messages: 65
Registered: July 2004

Member

Hi,

I have a Oracle exported .dmp file. Is it possible to know from that file that from which version of Oracle (Oracle 8 or 8i or 9i) the dump file has been generated??

Thanks in advance...

Avra

Report message to a moderator

Re: Oracle Version [message #139983 is a reply to message #139974]

Fri, 30 September 2005 07:05

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

A wild guess,
When i opened an exp dump file in an editor , i got this

 ²EXPORT:V09.02.00
URAJESH
RUSERS
2048
0
20

I exported it from Version 9.2.0 and the user was RAJESH.
And you can interpret that from the above two lines.

Try this meanwhile you get a perfect reply.

regards,
tarun

Report message to a moderator

oracle version [message #139991 is a reply to message #139971]

Fri, 30 September 2005 07:42

Avra
Messages: 65
Registered: July 2004

Member

Hi,

I have a Oracle exported .dmp file. Is it possible to know from that file that from which version of Oracle (Oracle 8 or 8i or 9i) the dump file has been generated??

Thanks in advance...

Avra

Report message to a moderator

Re: oracle version [message #139997 is a reply to message #139991]

Fri, 30 September 2005 07:53

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Dont post the same problem 3 times.

Report message to a moderator

Re: Oracle Version [message #140015 is a reply to message #139983]

Fri, 30 September 2005 08:43

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

Senior Member
Account Moderator

Never edit the dump file!.
It is an oracle proprietory binary file.
Any other editor may corrupt the dump file and you loose your oracle support.
use show=y to see the contents of the file you get the header information as shown
------------------------------------
oracle@mutation#imp scott/tiger fromuser=somejunkuser touser=anotherjunkuser file=scott1.dmp show=y

Import: Release 9.2.0.4.0 - Production on Fri Sep 30 09:40:27 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
-------------------------------------------

i am not very sure about this.
It does say, exported using 9.2 exp tool.
But doesnt say the version of the database that it exported.
I will check on this and keep you posted.

Report message to a moderator

Re: Oracle Version [message #140153 is a reply to message #140015]

Sat, 01 October 2005 08:03

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Mahesh, thanks for the information .

Report message to a moderator

Re: Oracle Version [message #140211 is a reply to message #140153]

Sun, 02 October 2005 13:36

Avra
Messages: 65
Registered: July 2004

Member

thank a lot to all of you... And the topic has been posted three times due to some internet connectivity problem... really sorry for that...

thanks,

avra

Report message to a moderator

Previous Topic:	IMP Problem
Next Topic:	SQL*Loader suggestion for huge records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:15:06 CDT 2024