OraFAQ Forum: Server Utilities » Dump file determination [merged 2 by jd]

Home » RDBMS Server » Server Utilities » Dump file determination [merged 2 by jd] (Oracle 11.2.0.3.0 , Linux 5.7)

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

Dump file determination [merged 2 by jd] [message #580931]

Fri, 29 March 2013 17:02

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

Is it possible to determine whether the dump file is created using data pump export or normal export method by just looking at dump file , If yes, could you tell how ?

Why i am asking such question is...normal export and data pump export would create a dump file with an same extension filename.dmp. So to avoid confusion during import, i would want to determine by what method the dump file was created.

Also this would be useful for me at the scenario when the customer sends me only the dumpfile and ask to import into target database. ( may be the customer don't know in what method the dump file was created ).

Regards,

[Updated on: Fri, 29 March 2013 17:30]

Report message to a moderator

Re: Dump file determination [message #580933 is a reply to message #580931]

Fri, 29 March 2013 17:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It appears that the space between your ears is empty.

imp user1/pass1 file=unknown.dmp show=Y
if no errors are thrown, then the file was made by exp, otherwise do similar test using impdp.

Report message to a moderator

Re: Dump file determination [message #580934 is a reply to message #580933]

Fri, 29 March 2013 18:02

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,

Quote:

It appears that the space between your ears is empty.

May i know why do you give such comment on me ?

[Updated on: Fri, 29 March 2013 18:02]

Report message to a moderator

Re: Dump file determination [message #580935 is a reply to message #580933]

Fri, 29 March 2013 18:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If database runs on a database server (which is different from your PC) and you see a DMP file in a directory located on your PC, then there's a good chance that it was created by the original EXP utility (because export data pump, EXPDP, creates files in a directory located on a database server) (unless you copied it from the server to your PC).

Or, view first several lines of the DMP file. If it is all scrambled and looks like this:

/forum/fa/10716/0/

/forum/fa/10716/0/

then it is most probably created by EXPDP.

If it looks like a readable file (like this):

/forum/fa/10715/0/

/forum/fa/10715/0/

then it might have been created by EXP.

Attachment: exp_expdp.JPG
(Size: 23.04KB, Downloaded 3463 times)
Attachment: exp_exp.JPG
(Size: 11.86KB, Downloaded 3537 times)

Report message to a moderator

Re: Dump file determination [message #580936 is a reply to message #580935]

Fri, 29 March 2013 19:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>May i know why do you give such comment on me ?
imp will not complain about (throw error) a file made by exp.
impdp will not complain about (throw error) a file made by expdp.
Above is intuitively obvious to the most casual observer.
So it is trivial to determine which utility was used to create any *dmp file; even trash.dmp that was made by any text editor.

Report message to a moderator

Re: Dump file determination [message #580937 is a reply to message #580935]

Fri, 29 March 2013 19:23

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you Littlefoot for the answers.

If anybody wants to add some more method to 'determine dumpfile' that you know you are welcome. Smile

Smile

Regards,

Report message to a moderator

Re: Dump file determination [message #580940 is a reply to message #580934]

Sat, 30 March 2013 01:05

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Jack14 wrote on Sat, 30 March 2013 00:02

Blackswan,

Quote:
It appears that the space between your ears is empty.

May i know why do you give such comment on me ?

I concur in the comment.
Given all the questions you posted I tend to think the same thing.
You should activate what is between your ears before posting and not look upon us as your brain.

Regards
Michel

Report message to a moderator

Re: Dump file determination [message #580944 is a reply to message #580940]

Sat, 30 March 2013 03:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Michel

not look upon us as your brain.

Why not? It is called external memory /forum/fa/1599/0/

/forum/fa/1599/0/

.

Report message to a moderator

Re: Dump file determination [message #580949 is a reply to message #580944]

Sat, 30 March 2013 03:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... and external CPU. Laughing

Laughing

Regards
Michel

Report message to a moderator

Re: Dump file determination [message #580967 is a reply to message #580949]

Sat, 30 March 2013 09:09

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

You should activate what is between your ears before posting and not look upon us as your brain.

I haven't heard anything from you Michel so far.Its all about what we scribble here and no such external memory and CPU is required.

Report message to a moderator

Re: Dump file determination [message #580980 is a reply to message #580967]

Sat, 30 March 2013 11:07

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Then you didn't read me carefully:
Maybe you should FIRST read the documentation, then think a little bit and then post questions.
2/ Think a little bit what is the purpose of this parameter
If you think a little bit, I think you will know the answer to your questions.
If you activate what is between your ears you should know the answer.
And this only in the first page of your topics.
Without speaking about each time I said the question is directly answered in the documentation. Do you want the links?

Regards
Michel

Report message to a moderator

Determine the export mode the dump file taken [message #581021 is a reply to message #580931]

Sun, 31 March 2013 19:18

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I have one question regarding determining the export mode that is being used in the dump file.

There is one situation when customer sends only dumpfile and wants to import into target database.Customer does not know
the details of dump file ( like what type of export mode the dump file was taken )

Here i want to find out the export mode the dump file was taken by just looking at dump file given by Customer. ( export mode like whether it is schema mode ( schema name),tablespace mode, full database mode, .... )

Could you tell how to find out that .

Regards,

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581022 is a reply to message #581021]

Sun, 31 March 2013 19:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

od -c dumpfile.dmp & inspect results for telltale clues.

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581023 is a reply to message #581022]

Sun, 31 March 2013 19:24

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,

i dont understand what you are saying.Could you be more specific to your answers.

[Updated on: Sun, 31 March 2013 19:24]

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581024 is a reply to message #581023]

Sun, 31 March 2013 19:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Did you even actually try what I posted?
I don't understand what you don't understand.

alternatively try as below

strings unknown.dmp

or use imp or impdp to produce text content of dump file as appropriate.

[Updated on: Sun, 31 March 2013 20:15]

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581032 is a reply to message #581021]

Mon, 01 April 2013 01:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For old export dump, see this.

Regards
Michel

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581043 is a reply to message #581032]

Mon, 01 April 2013 05:13

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

strings expdat.dmp | head -5
strings unknown.dmp

Could you tell me what is this and where to execute it ?

Regards,
Jack

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581049 is a reply to message #581043]

Mon, 01 April 2013 05:37

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Also when i try to follow show=y method , i get failed to open dump file.

[oracle@RAC1 ~]$ imp username/pwd file =unlnown.dmp log=unknown.log show=y

Import: Release 11.2.0.3.0 - Production on Mon Apr 1 10:32:34 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes

IMP-00002: failed to open unlnown.dmp for read
Import file: expdat.dmp >

IMP-00002: failed to open expdat.dmp for read
Import file: expdat.dmp > exit

Dont know how to come out of this command line .

Regards,

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581051 is a reply to message #581049]

Mon, 01 April 2013 05:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you have the UNLNOWN.DMP file?

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581053 is a reply to message #581043]

Mon, 01 April 2013 05:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Jack14 wrote on Mon, 01 April 2013 12:13

strings expdat.dmp | head -5
strings unknown.dmp
Could you tell me what is this and where to execute it ?

Regards,
Jack

man strings

Regards
Michel

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581054 is a reply to message #581049]

Mon, 01 April 2013 05:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Jack, once more, activate what is or should be between your ears.
Don't you think that unknown.dmp and expdat.dmp are just examples? We don't know your file name.
Are you REALLY so dump?

Regards
Michel

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581058 is a reply to message #581054]

Mon, 01 April 2013 06:39

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

littlefoot,

Quote:

Do you have the UNLNOWN.DMP file?

yes

Michel,
I am not dump. I above dump is available in the server path and i did as you said but dont know why i am getting such thing.

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581059 is a reply to message #581058]

Mon, 01 April 2013 06:56

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If Oracle says it can't reach the file then you can trust it (and your OS).
The error is yours not the other part one.
Check again.

Regards
Michel

Report message to a moderator

Re: Determine the export mode the dump file taken [message #581078 is a reply to message #581059]

Mon, 01 April 2013 10:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Jack

above dump is available in the server path

Does it mean that the DMP file is located in a directory on a database server? If so, regarding the previous discussion, is it created by export data pump (EXPDP) and not the original export (EXP) utility? If so, you should use IMPDP (not IMP) whose syntax is somewhat different from IMPs (for example, you need to specify DIRECTORY parameter value); for more details, consult the IMPDP documentation.

Report message to a moderator

Previous Topic:	SQL Loader - Skipping one column which shouldnot
Next Topic:	ORA-01466: unable to read data - table definition has changed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:21:39 CST 2025