Printable View
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.
I think the file is corrupted.The default extention is .dmp
why you dont simply do
imp show=y using the dmp???
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 thenQuote:
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.
man, and what´s so hard rename the file to smth DMP...? 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).Quote:
Originally posted by pando
use some common sense
So if it doesn't have an extension, use this:
c:\DUMPS\test\01142005>imp system/manager file=exp_test_dmp. show=y
I consistantly bow to Pando's level of political correctness.