dump files question

[learning_bee]

could a dump file without the extension .dmp??? I have trouble with one of the file that was sent to me from the client and the file only have exp_test_dmp without .dmp. I did a test on my machine and even I didn't specify with .dmp, Oracle still automatically had .dmp once the export is completed.

the question is the file exp_test_dmp without .dmp is a good file???

thanks and have a great weekend.

[akhadar]

I think the file is corrupted.The default extention is .dmp

[pando]

why you dont simply do

imp show=y using the dmp???

[learning_bee]

Pando,

that's verry first thing I did before I raise the question in this forum. Below is file info from dos prompt:

01/14/2005 04:53p .
01/14/2005 04:53p ..
01/12/2005 04:39p 43,234 exp_test.log
01/14/2005 04:05p 4,031,323,098 exp_test_dmp


the exp log file indicated that the file was export succefully without warnings. Below is the errors I got when I try to read the contents of the dump:


c:\DUMPS\test\01142005>set oracle_sid=test

c:\DUMPS\test\01142005>imp system/manager file=exp_test_dmp log=imp_tes
t.log full=y show=y

Import: Release 9.2.0.6.0 - Production on Sat Jan 15 09:06:23 2005

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

IMP-00002: failed to open exp_test_dmp.DMP for read
Import file: EXPDAT.DMP >

It kept looking for the file and the file is there, as I mentioned earlier I think the file is corrupted b/c when I try to do the test on the export even I don't specify .DMP, Oracle will automaticaly had .DMP on the file when the export is done.

[davey23uk]

Originally posted by learning_bee
Pando,

that's verry first thing I did before I raise the question in this forum. Below is file info from dos prompt:

01/14/2005 04:53p .
01/14/2005 04:53p ..
01/12/2005 04:39p 43,234 exp_test.log
01/14/2005 04:05p 4,031,323,098 exp_test_dmp


the exp log file indicated that the file was export succefully without warnings. Below is the errors I got when I try to read the contents of the dump:


c:\DUMPS\test\01142005>set oracle_sid=test

c:\DUMPS\test\01142005>imp system/manager file=exp_test_dmp log=imp_tes
t.log full=y show=y

Import: Release 9.2.0.6.0 - Production on Sat Jan 15 09:06:23 2005

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

IMP-00002: failed to open exp_test_dmp.DMP for read
Import file: EXPDAT.DMP >

It kept looking for the file and the file is there, as I mentioned earlier I think the file is corrupted b/c when I try to do the test on the export even I don't specify .DMP, Oracle will automaticaly had .DMP on the file when the export is done.

give the file a .dmp extension then

[pando]

man, and what´s so hard rename the file to smth DMP...? use some common sense

[jmodic]

Originally posted by pando
use some common sense

.... or use a "." after the filename (in situation that for whatever reason you can't rename it - for example when it's on CD or on readonly directory or something like that).

So if it doesn't have an extension, use this:

c:\DUMPS\test\01142005>imp system/manager file=exp_test_dmp. show=y

[Mr.Hanky]

I consistantly bow to Pando's level of political correctness.