Home » RDBMS Server » Server Utilities » Dump file determination [merged 2 by jd] (Oracle 11.2.0.3.0 , Linux 5.7)
Dump file determination [merged 2 by jd] [message #580931] Fri, 29 March 2013 17:02 Go to next message
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 Go to previous messageGo to next message
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.
Re: Dump file determination [message #580934 is a reply to message #580933] Fri, 29 March 2013 18:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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/

then it is most probably created by EXPDP.

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

/forum/fa/10715/0/

then it might have been created by EXP.

  • Attachment: exp_expdp.JPG
    (Size: 23.04KB, Downloaded 2483 times)
  • Attachment: exp_exp.JPG
    (Size: 11.86KB, Downloaded 2532 times)
Re: Dump file determination [message #580936 is a reply to message #580935] Fri, 29 March 2013 19:17 Go to previous messageGo to next message
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.
Re: Dump file determination [message #580937 is a reply to message #580935] Fri, 29 March 2013 19:23 Go to previous messageGo to next message
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

Regards,
Re: Dump file determination [message #580940 is a reply to message #580934] Sat, 30 March 2013 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Dump file determination [message #580944 is a reply to message #580940] Sat, 30 March 2013 03:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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/ .
Re: Dump file determination [message #580949 is a reply to message #580944] Sat, 30 March 2013 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... and external CPU. Laughing

Regards
Michel
Re: Dump file determination [message #580967 is a reply to message #580949] Sat, 30 March 2013 09:09 Go to previous messageGo to next message
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.
Re: Dump file determination [message #580980 is a reply to message #580967] Sat, 30 March 2013 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Determine the export mode the dump file taken [message #581021 is a reply to message #580931] Sun, 31 March 2013 19:18 Go to previous messageGo to next message
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,
Re: Determine the export mode the dump file taken [message #581022 is a reply to message #581021] Sun, 31 March 2013 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
od -c dumpfile.dmp & inspect results for telltale clues.
Re: Determine the export mode the dump file taken [message #581023 is a reply to message #581022] Sun, 31 March 2013 19:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For old export dump, see this.

Regards
Michel
Re: Determine the export mode the dump file taken [message #581043 is a reply to message #581032] Mon, 01 April 2013 05:13 Go to previous messageGo to next message
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
Re: Determine the export mode the dump file taken [message #581049 is a reply to message #581043] Mon, 01 April 2013 05:37 Go to previous messageGo to next message
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,
Re: Determine the export mode the dump file taken [message #581051 is a reply to message #581049] Mon, 01 April 2013 05:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you have the UNLNOWN.DMP file?
Re: Determine the export mode the dump file taken [message #581053 is a reply to message #581043] Mon, 01 April 2013 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Determine the export mode the dump file taken [message #581054 is a reply to message #581049] Mon, 01 April 2013 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Determine the export mode the dump file taken [message #581058 is a reply to message #581054] Mon, 01 April 2013 06:39 Go to previous messageGo to next message
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.
Re: Determine the export mode the dump file taken [message #581059 is a reply to message #581058] Mon, 01 April 2013 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Determine the export mode the dump file taken [message #581078 is a reply to message #581059] Mon, 01 April 2013 10:01 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: SQL Loader - Skipping one column which shouldnot
Next Topic: ORA-01466: unable to read data - table definition has changed
Goto Forum:
  


Current Time: Thu Mar 28 04:57:54 CDT 2024