Export problem.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Export problem.

  1. #1
    Join Date
    Aug 2000
    Posts
    25

    Export problem.

    Oracle : 8i
    Solaris : 8

    -----------------------------------


    . about to export XYZ's tables via Conventional Path ...
    . . exporting table STREET_AL 466880 rows exported
    . . exporting table STREET_AR 398841 rows exported
    . . exporting table STREET_AZ 377858 rows exported
    . . exporting table STREET_CA 1558305 rows exported
    . . exporting table STREET_CO 397432 rows exported
    . . exporting table STREET_CT 185807 rows exported
    . . exporting table STREET_DC 17572 rows exported
    . . exporting table STREET_DE 63807 rows exported
    . . exporting table STREET_FL 1237520 rows exported
    . . exporting table STREET_GA 697323 rows exported
    . . exporting table STREET_IA 410395 rows exported
    . . exporting table STREET_ID 162258 rows exported
    . . exporting table STREET_IL 943717 rows exported
    . . exporting table STREET_IN 576405 rows exported
    . . exporting table STREET_KS 427038 rows exported
    . . exporting table STREET_KY 379777 rows exported
    . . exporting table STREET_LA 425243 rows exported
    . . exporting table STREET_MA 377629 rows exported
    . . exporting table STREET_MD 309608 rows exported
    . . exporting table STREET_ME 142321 rows exported
    . . exporting table STREET_MI 712903 rows exported
    . . exporting table STREET_MN 548022 rows exported
    . . exporting table STREET_MO 622111 rows exported
    . . exporting table STREET_MS 289272 rows exported
    . . exporting table STREET_MT 141816 rows exported
    . . exporting table STREET_NC 813093 rows exported
    . . exporting table STREET_ND 185487 rows exported
    . . exporting table STREET_NE 234219 rows exported
    . . exporting table STREET_NH 110628 rows exported
    . . exporting table STREET_NJ
    EXP-00015: error on row 196247 of table STREET_NJ, column STREET_NAME, datatype 1
    EXP-00222:
    System error message 27
    EXP-00002: error in writing to export file
    EXP-00002: error in writing to export fileSegmentation Fault

    Any idea why my export keep crashing?

    Thanks.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    check how much space remaining in the export location.

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

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Aug 2000
    Posts
    25
    Only 46% full. It is writing to a local disk.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    What is the size of the xport file..? Is LARGEFILES enabled in the file system level
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Aug 2000
    Posts
    25
    It more then 6 gig. How do I check and change LARGEFILES enabled in the file system level?

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Check with your system administrator. Also check the ulimit for the oracle user...
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    Aug 2000
    Posts
    25
    ulimit for oracle:

    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) unlimited
    stack(kbytes) 8192
    coredump(blocks) 0
    nofiles(descriptors) 256
    vmemory(kbytes) unlimited

  8. #8
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    go to the export directory and run the commands .. post it

    df -k .
    ls -l
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  9. #9
    Join Date
    Aug 2000
    Posts
    25
    ls -la


    total 5189592
    drwxrwxrwx 2 oracle dba 4096 Dec 3 12:36 .
    drwxrwxrwx 14 root root 4096 Jan 7 2003 ..
    -rw-r--r-- 1 oracle dba 2147483647 Dec 3 12:59 xyz.dmp

    df -k

    /dev/md/dsk/d64 118492036 52738560 65753476 45% /a10_02d

  10. #10
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    It more then 6 gig. How do I check and change LARGEFILES enabled in the file system level?
    -rw-r--r-- 1 oracle dba 2147483647 Dec 3 12:59 xyz.dmp

    ie 2147483647 bytes = 1.99999GB

    From where di you get 6GB???

    Use compress method of export or
    split the export file.

    Anyhow LARGEFILES will not help you..

    See this..
    http://www.dbasupport.com/forums/sho...light=EXP00015

    http://www.dbasupport.com/forums/sho...threadid=37714
    Last edited by Thomasps; 12-04-2003 at 07:49 AM.
    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