exp failing with non zero return code
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: exp failing with non zero return code

  1. #1
    Join Date
    Jun 2010
    Posts
    3

    exp failing with non zero return code

    I am on windoes NT and oracle version 10.2.0.4 .
    Doing exp full=y ; and getting ora-1466 error and exp returning with non zero return code.that error dose not comes if we use expdp.

    FOR example i have tried a simple scenario-
    whether there is one table(test1) present and one is not(test2).
    exp tables=test1,test2

    C:\>exp tables= test1,test2

    Export: Release 10.2.0.2.0 - Production on Fri Jun 11 13:55:16 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Username: dev
    Password:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table TEST1 6291456 rows exported
    EXP-00011: DEV.TEST2 does not exist
    Export terminated successfully with warnings.

    C:\>echo %ERRORLEVEL%
    3




    and with expdp

    C:\>expdp tables= test1,test2

    Export: Release 10.2.0.2.0 - Production on Friday, 11 June, 2010 13:57:39

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Username: dev
    Password:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Starting "DEV"."SYS_EXPORT_TABLE_01": dev/******** tables= test1,test2
    Estimate in progress using BLOCKS method...
    Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
    Total estimation using BLOCKS method: 84.38 MB
    Processing object type TABLE_EXPORT/TABLE/TABLE
    Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
    . . exported "DEV"."TEST1" 42.00 MB 6291456 rows
    ORA-39166: Object TEST2 was not found.
    Master table "DEV"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
    ******************************************************************************
    Dump file set for DEV.SYS_EXPORT_TABLE_01 is:
    D:\ORACLE\PRODUCT\10.2.0\RDBMS\LOG\EXPDAT.DMP
    Job "DEV"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 13:57:59


    C:\>echo %ERRORLEVEL%
    0


    want some solution on this is this is a defect from oracle side exp utility.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    don't include tables which dont exist?

  3. #3
    Join Date
    Jun 2010
    Posts
    3
    ya ..
    I dont have problem with that ..
    I have problem with return code what was given by exp ..
    Its just a example i have given ..for some other scenarios also it gives non zero return code .

    I have cheked this example on unix/linux.
    it shows
    > exp tables=temp,temp3

    Export: Release 10.2.0.1.0 - Production on Fri Jun 11 16:52:48 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Username: dev
    Password:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Export done in US7ASCII character set and AL16UTF16 NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table TEMP 3 rows exported
    EXP-00011: DEV.TEMP3 does not exist
    Export terminated successfully with warnings.
    > echo $?
    0

    is it a exp defect

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by shirishbhalekar View Post
    is it a exp defect
    Really?

    Quote Originally Posted by shirishbhalekar View Post
    EXP-00011: DEV.TEMP3 does not exist
    Error message doesn't look like a "exp defect".

    Start by showing us DEV.TEMP3 do exist.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jun 2010
    Posts
    3
    i have issue with different return code on windows (non zero) and unix/linux (zero) machine.

    so I don't getting why exp showing two different return codes ?
    Thats why i am askink is it a exp defect or any other .

    I have given a scenario for this.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    why do you even care, return code is useless, the oracle error message is useful

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by shirishbhalekar View Post
    Export terminated successfully with warnings.
    > echo $?
    0
    This is expected behavior.

    Let me quote Oracle documentation:
    "Export issues the following return codes:
    0 is a normal (successful) completion. Review results carefully as a 0 return code can indicate an error not serious enough to terminate the utility, but invalidates the Export file.
    8 is an end due to an irrecoverable error.
    "
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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