Export Problem - Hanging
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Export Problem - Hanging

  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Lightbulb Export Problem - Hanging

    Hi all,

    Oracle Ver : 8.1.7.2
    OP : Sun Solaris 2.7

    Problem:-

    I've tried exporting a table which has 23 million records (3.1gb) twice and both times it hung at the same point - I put feedback on and it stops at 15 million records (587mb - compressed). I've create a pipe and compressing the pipe to my dump file....

    Also, when I try and do a select Count(0) from this table the whole db runs very slow, nearly to a halt...

    I've tried the dbverify command on each of my datafiles and it reported no corruption... When not selecting on this table the db is fine with no problems at all


    Any ideas????


  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I the gzip actually transfering from the pipe to the .dmp . or is the pipe just growing and growing and eventually filling the filesystem?

    When running the exp, make sure the .dmp file in with you are piping to is growing and not only the pipe...

    Specifically:

    nohup gzip < gzip_pipe > exportfile.dmp.gz &

    Cheers...
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jan 2003
    Posts
    35
    the pipe is working properly - I was watching the pipe grow then back to 0 and the dmp file was getting bigger and bigger....

    Could the table be corrupt?? - Select count(0) is killing the db!

    How do I check to see if it is?

    Thanks in advance

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    analyze table table_name validate structure;
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Jan 2003
    Posts
    35
    As my db is in CHOOSE mode, but runs in RULE. If I analyze a table it will force it into COST and the db will run like a dog?!

    Is there a way around this??

  6. #6
    Join Date
    Nov 2001
    Posts
    11

    Re: Export Problem - Hanging

    Originally posted by krw
    Hi all,

    Oracle Ver : 8.1.7.2
    OP : Sun Solaris 2.7

    Problem:-

    I've tried exporting a table which has 23 million records (3.1gb) twice and both times it hung at the same point - I put feedback on and it stops at 15 million records (587mb - compressed). I've create a pipe and compressing the pipe to my dump file....

    Also, when I try and do a select Count(0) from this table the whole db runs very slow, nearly to a halt...

    I've tried the dbverify command on each of my datafiles and it reported no corruption... When not selecting on this table the db is fine with no problems at all


    Any ideas????


  7. #7
    Join Date
    Jan 2003
    Posts
    35
    Amrgon - Any advice?

  8. #8
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    It won't actully calculate the statistics.

    But for future reference you can...

    analyze table table_name delete statistics;
    OCP 8i, 9i DBA
    Brisbane Australia

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    Well, let me ask the obvious.

    Are you blowing out the mount point?

    MH
    I remember when this place was cool.

  10. #10
    Join Date
    Jan 2003
    Posts
    35
    No - we are only using 37%

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