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.
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
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.
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. "
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.
Reply With Quote
Originally Posted by shirishbhalekar
Bookmarks