10gR2 Datapump EXPORT error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: 10gR2 Datapump EXPORT error

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    10gR2 Datapump EXPORT error

    Oracle 10gR2 and Solaris10.

    Iam trying to take a datapump back up of a schema 'DSS', and i get this error message..here are the details..I have about 25GB space left on that file system.

    ====================================
    SQL> SELECT * FROM dba_directories;

    OWNER DIRECTORY_NAME DIRECTORY_PATH
    ----------------------------------------------------------
    SYS DPUMP_DIR1 /tmp/dump_dir
    SYS WORK_DIR /ade/aime_ship_10gR2_050630/oracle/work
    SYS DATA_PUMP_DIR /u10/app/ORACLE/product/10.2.0.1/rdbms/log/
    SYS ADMIN_DIR /ade/aime_ship_10gR2_050630/oracle/md/admin


    $expdp system/password@dss DIRECTORY=DATA_PUMP_DIR dumpfile=dssdp.dmp schema=dss

    Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 19 April, 2007 11:02:34

    Copyright (c) 2003, 2005, Oracle. All rights reserved.
    ;;;
    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02": system/********@dss DIRECTORY=DATA_PUMP_DIR dumpfile=dssdp.dmp schemas=dss
    Estimate in progress using BLOCKS method...
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    Total estimation using BLOCKS method: 9.202 GB
    Processing object type SCHEMA_EXPORT/USER
    Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
    Processing object type SCHEMA_EXPORT/ROLE_GRANT
    Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
    ....
    ....
    ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
    ORA-31644: unable to position to block number 1 in dump file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp"
    ORA-19502: write error on file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp", blockno 892675 (blocksize=4096)
    ORA-27063: number of bytes read/written is incorrect
    SVR4 Error: 28: No space left on device
    Additional information: -1
    Additional information: 262144
    ORA-19502: write error on file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp", blockno 892483 (blocksize=4096)
    ORA-27063: number of bytes read/written is incorrect
    SVR4 Error: 28: No space left on device
    Additional information: -1
    Additional information: 262144

    ==============================

    I am trying to export DSS schema using System account, and the DIRECTORY _NAME is DATA_PUMP_DIR


    any help is appreciated..

    Thanks
    Ron

  2. #2
    Join Date
    Apr 2007
    Posts
    33

    Datapump Export Error

    From the error you are getting, there is no space on the device. Free up space and then repeat the process. Please let us know how you get on.

    Thanks

    Naa

  3. #3
    Join Date
    Apr 2007
    Posts
    33
    Have you checked permissions on this file?

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    No space left on the device to write the file dssdp.dmp. Check again for space when it fails.

  5. #5
    Join Date
    Apr 2007
    Posts
    33
    Please check the space available again.

  6. #6
    Join Date
    Oct 2002
    Posts
    284
    here is my df -h commnad

    [oraosc:/u10/app/ORACLE/admin/dss]df -h
    Filesystem size used avail capacity Mounted on
    / 12G 11G 282M 98% /
    /dev 12G 11G 282M 98% /dev
    /lib 12G 11G 282M 98% /lib
    /opt/emc 12G 11G 282M 98% /opt/emc
    /platform 12G 11G 282M 98% /platform
    /sbin 12G 11G 282M 98% /sbin
    /syshome 3.9G 357M 3.6G 9% /syshome
    /u10/app/ORACLE/oradata
    25G 1.7G 23G 7% /u10/app/ORACLE/oradata
    /u100/app/ORACLE/oradata
    9.8G 2.2G 7.5G 23% /u100/app/ORACLE/oradata
    /u110/app/ORACLE/oradata
    9.8G 1.6G 8.1G 17% /u110/app/ORACLE/oradata
    /u120/app/ORACLE/oradata
    9.8G 2.6G 7.1G 28% /u120/app/ORACLE/oradata
    /u20/app/ORACLE/oradata
    9.8G 3.8G 6.0G 39% /u20/app/ORACLE/oradata
    /u30/app/ORACLE/oradata
    9.8G 2.5G 7.2G 26% /u30/app/ORACLE/oradata
    /u40/app/ORACLE/oradata
    9.8G 3.0G 6.7G 32% /u40/app/ORACLE/oradata
    /u50/app/ORACLE/oradata
    9.8G 3.6G 6.1G 38% /u50/app/ORACLE/oradata
    /u60/app/ORACLE/oradata
    9.8G 3.3G 6.4G 34% /u60/app/ORACLE/oradata
    /u70/app/ORACLE/oradata
    9.8G 2.5G 7.2G 26% /u70/app/ORACLE/oradata
    /u80/app/ORACLE/oradata
    9.8G 2.4G 7.3G 25% /u80/app/ORACLE/oradata
    /u90/app/ORACLE/oradata
    9.8G 3.0G 6.7G 31% /u90/app/ORACLE/oradata

    ===================================

    Obviously, i have allocated 25 GB for '/u10/app/ORACLE/oradata' file system and the dump file is writing at 'u10/app/ORACLE/product/10.2.0.1/rdbms/log/' directory..

    So i dont think, space is an issue. As far as Permissions, it has already written like 3 GB of data before it throws this error..so, Permissions are not an issue.

    any ideas ?

    thanks
    Ron

  7. #7
    Join Date
    Apr 2007
    Posts
    33
    What about dropping the data_dump_dir and recreating it?

  8. #8
    Join Date
    Apr 2007
    Posts
    33
    I mean recreate using create directory as '....'

  9. #9
    Join Date
    Oct 2002
    Posts
    284
    Data_DUMP_DIR is created by default during DBCA installation of the DB..not sure, how can delete it thru SQL statements..

  10. #10
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    It seems to be that the server has problem in async I/O on the file system.
    Did you enable large file system on this mount point?

    You can check this using mount command.

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