-
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
-
don't include tables which dont exist?
-
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
-
Originally Posted by shirishbhalekar
is it a exp defect
Really?
Originally Posted by shirishbhalekar
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.
-
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.
-
why do you even care, return code is useless, the oracle error message is useful
-
Originally Posted by shirishbhalekar
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|