EXPORT Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: EXPORT Problem

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Red face

    Hi All

    I got a Database of 75GB. When taking export (FULL=Y) the dump file is created upto 2GB (Exactly 2147483647 May 23 00:04 EXPsib220502.dmp ) and terminating giving the error as follows.

    . . exporting table TD_DEFN_TABLE
    EXP-00015: error on row 141887 of table TD_DEFN_TABLE, column ACID, datatype 1
    EXP-00002: error in writing to export file
    EXP-00002: error in writing to export file
    EXP-00000: Export terminated unsuccessfully

    It was exporting with out any problems to this size. I am sure the problem is associated with the size of the dump file..! But how to solve..? What could be the solution.. !??

    Please help!

    Thanking in advance

    Thomas

    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    This is most certainly because you have reached your max OS filesize limit.

    What is your OS ?

    I unix you can set ulimit -f unlimited to have an unlimited file size for that sessions.
    Hard and Soft file size kernal parameters can be set to unlimited for the whole system if you wish, talk to your Unix SA.
    ulimit -a usually shows you current settings.

    There are also other ways of generating an export fle less than 2GB's, one way is to split the exports up. Search forums on how to do this, there have been many threads on this subject.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi

    Thanks..

    marist .. I will check it out..

    Sureshy:

    1. My ulimit is unlimited

    # ulimit
    unlimited

    2. I am using veritas file system (vxfs). All my file systems mounted with largefiles option..

    /exp on /dev/vx/dsk/dbdg/vol05 read/write/setuid/log/largefiles/ioerror=mwdisable/dev=3799a2c on Wed May 22 00:52:40 2002


    So do you think that it could be a problem..

    Regards

    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Jeff has provided you with a good solution, there are some good scripts in the tips section.

    If you rellay want to look into unlimiting your file max block size then :

    a.Log in as the user runing the export(oracle) NOT root.

    b. ulimit on it's own is not good enough. you need to specify a parameter as there are many resource limits that ulimit will supply information on. 'man ulimit' will tell you what each parameter means, use the right one!

    ulimit -f usually tells you max number of blocks on files.
    ulimit -a usually lists limits for all resources.

    You need to know max number of blocks on files.

    You can either set ulimit -f unlimited for current session or change kernal parameters
    In SCO Unixware SFSZLIM and HFSZLIM are set to 0x7FFFFFFF for unlimited.

    For further help on your flavour of unix visit :
    http://www.unix.com

    Suresh





    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    I have had this problem on our HP/UX boxes here. We have to contact the Unix Sys Admin and have him enable large files on the specified mount points. I guess it is a Unix default, not sure though.

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Exoprt

    Hi

    Thanks all..

    Now I am trying with the pipe option with compressing. Well, I have Solaris 8 with Vxsfs file system. We enabled largefiles in the /etc/vfstab. So system should not stop at 2GB. Pleae somebody tell me why the export is terminated at 2GB... If I am correct, a file can grow upto 2TB in vxfs largefiles.. So how I am getting the error..???

    Currently I took the export backup and the .Z size is 153MB... Wow..life is very easy.. if the things are known..!

    Thanks to all..
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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