DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: dump files question

Hybrid View

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    dump files question

    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.

  2. #2
    Join Date
    May 2001
    Posts
    736
    I think the file is corrupted.The default extention is .dmp

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you dont simply do

    imp show=y using the dmp???

  4. #4
    Join Date
    Oct 2003
    Posts
    312
    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.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    man, and what´s so hard rename the file to smth DMP...? use some common sense

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Jan 2001
    Posts
    3,134
    I consistantly bow to Pando's level of political correctness.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width