exp failing with non zero return code

[shirishbhalekar]

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

[davey23uk]

don't include tables which dont exist?

[shirishbhalekar]

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

[PAVB]

is it a exp defect

Really?

EXP-00011: DEV.TEMP3 does not exist

Error message doesn't look like a "exp defect".

Start by showing us DEV.TEMP3 do exist.

[shirishbhalekar]

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.

[davey23uk]

why do you even care, return code is useless, the oracle error message is useful

[PAVB]

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. "