469,127 Members | 1,413 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

exp utility

1
Hi,
I tried to export a schema using the exp utility for ora8.1. All the tables and other objects where exported, but at the last stage an error occured. wats the reason for this?



. . exporting table PXC_SELECT 99 rows exporte
. . exporting table PXC_SORT 14 rows exporte
. . exporting table PXC_SORT_FIELD 19 rows exporte
. . exporting table PXC_SPREAD_CURVE 0 rows exporte
. . exporting table PXC_STANDARD_OUT 7 rows exporte
. . exporting table PXC_STD_EXPORT 3 rows exporte
. . exporting table PXC_STD_EXP_FLD 18 rows exporte
. . exporting table PXC_WIN_REP 32 rows exporte
. . exporting table PXC_WIN_REP_FLD 178 rows exporte
. . exporting table PXP_ACTIVITY 74 rows exporte
. . exporting table PXP_ASN_CST_ACT 0 rows exporte
. . exporting table PXP_ASN_CST_EST 0 rows exporte
. . exporting table PXP_ASN_SCH_ACT 0 rows exporte
. . exporting table PXP_ASN_SCH_EST 66 rows exporte
. . exporting table PXP_LIST_ITEMS 0 rows exporte
. . exporting table PXP_LOGIC 42 rows exporte
. . exporting table PXP_PROJECT 1 rows exporte
. . exporting table PXR_AVAILABILITY 673 rows exporte
. . exporting table PXR_BURDEN 0 rows exporte
. . exporting table PXR_BURDEN_RATE 0 rows exporte
. . exporting table PXR_COST_CAT 4 rows exporte
. . exporting table PXR_HOLIDAY 0 rows exporte
. . exporting table PXR_HOLIDAY_DATE 0 rows exporte
. . exporting table PXR_INDIVIDUALS 0 rows exporte
. . exporting table PXR_IND_AVAIL 0 rows exporte
. . exporting table PXR_IND_BURDEN 0 rows exporte
. . exporting table PXR_IND_RATE 0 rows exporte
. . exporting table PXR_RESOURCES 18 rows exporte
. . exporting table PXR_RES_BURDEN 0 rows exporte
. . exporting table PXR_RES_RATE 18 rows exporte
. . exporting table PXR_UTILITY 1 rows exporte
. . exporting table PXR_WORKWEEK 2 rows exporte
. . exporting table PX_ROWCOUNT 1 rows exporte
. . exporting table QUERY 1 rows exporte
. . exporting table QUOTATIONLINE 4 rows exporte
. . exporting table QUOTATIONLINE_PG1 0 rows exporte
. . exporting table R2_STD01 97 rows exporte
. . exporting table R2_STD02 79 rows exporte
. . exporting table RANGEDOMSEGMENT 0 rows exporte
. . exporting table REORDER 0 rows exporte
. . exporting table REORDERMUTEX 0 rows exporte
. . exporting table REORDERPAD 0 rows exporte
. . exporting table REPORT 94 rows exporte
. . exporting table REPORT_TRANSPORT 0 rows exporte
. . exporting table RFQ 2 rows exporte
. . exporting table RFQLINE 8 rows exporte
. . exporting table RFQSTATUS 6 rows exporte
. . exporting table RFQVENDOR 6 rows exporte
. . exporting table ROUTES 3 rows exporte
. . exporting table ROUTE_STOP 12 rows exporte
. . exporting table SAFETYLEXICON 27 rows exporte
. . exporting table SAFETYPLAN 2 rows exporte
. . exporting table SAMPLE 2 rows exporte
. . exporting table SCHARGES 5 rows exporte
. . exporting table SCHARGES_PG1 2 rows exporte
. . exporting table SERVICECONTRACT 3 rows exporte
. . exporting table SERVRECTRANS 8 rows exporte
. . exporting table SERVRECTRANS_PG1 348 rows exporte
. . exporting table SHIFT 4 rows exporte
. . exporting table SHIFTPATTERNDAY 28 rows exporte
. . exporting table SHIPMENT 0 rows exporte
. . exporting table SHIPMENTLINE 0 rows exporte
. . exporting table SIGOPTION 965 rows exporte
. . exporting table SPACE_NULL_TEST 2 rows exporte
. . exporting table SPAREPART 72 rows exporte
. . exporting table SPLEXICONLINK 5 rows exporte
. . exporting table SPRELATEDASSET 5 rows exporte
. . exporting table SPWORKASSET 3 rows exporte
. . exporting table SURESH 0 rows exporte
. . exporting table SURESH_TEST 7 rows exporte
. . exporting table TAGLOCK 14 rows exporte
. . exporting table TAGOUT 5 rows exporte
. . exporting table TAX 34 rows exporte
. . exporting table TAXCODE_MAPPING 5 rows exporte
. . exporting table TAXTYPE 5 rows exporte
. . exporting table TAX_PG1 5 rows exporte
. . exporting table TCA 0 rows exporte
. . exporting table TEMP_CCDESC 130 rows exporte
. . exporting table TEMP_CCDESC_CBU 150 rows exporte
. . exporting table TEMP_COMPCODE 9 rows exporte
. . exporting table TEMP_EQMAPPING 1 rows exporte
. . exporting table TEMP_MAPDATA 826 rows exporte
. . exporting table TEMP_MAPDATA_CBU 1120 rows exporte
. . exporting table TEMP_R2_STD01 97 rows exporte
. . exporting table TEMP_SURESH 259 rows exporte
. . exporting table TEMP_VENDOR 8117 rows exporte
. . exporting table TEMP_ZFAFE 5524 rows exporte
. . exporting table TEST1 9 rows exporte
. . exporting table TESTAPP 0 rows exporte
. . exporting table TESTCA 0 rows exporte
. . exporting table TEST_ABC 16 rows exporte
. . exporting table TEST_ALITEM 30 rows exporte
. . exporting table TEST_CURSOR 10 rows exporte
. . exporting table TEST_MOBIN 1 rows exporte
. . exporting table TEST_PR 81 rows exporte
. . exporting table TIMEPASS 7 rows exporte
. . exporting table TLEAVE 5 rows exporte
. . exporting table TMP1_PCARD_MAXIMOCP 2244 rows exporte
. . exporting table TMP2 0 rows exporte
. . exporting table TMP_EQUIP 1 rows exporte
. . exporting table TMP_ITEM_QTY 187 rows exporte
. . exporting table TMP_PCARD_MAXIMOCP 2244 rows exporte
. . exporting table TMP_TABLE 0 rows exporte
. . exporting table TOLERANCE 3 rows exporte
. . exporting table TOOL 25 rows exporte
. . exporting table TOOLTRANS 2 rows exporte
. . exporting table TPRD 1166 rows exporte
. . exporting table TRANS 0 rows exporte
. . exporting table TRANSLATION 2 rows exporte
. . exporting table USERGROUPAUTH 21 rows exporte
. . exporting table USERPREF 72 rows exporte
. . exporting table USERRESTRICTIONS 936 rows exporte
. . exporting table VALUELIST 378 rows exporte
. . exporting table VALUELISTDOMAIN 68 rows exporte
. . exporting table VENDCONF 0 rows exporte
. . exporting table VENDOR 20328 rows exporte
. . exporting table VENDORCODE_MAPPING 8681 rows exporte
. . exporting table VENDORSTATUS 0 rows exporte
. . exporting table VERITYACTION 11 rows exporte
. . exporting table W33RDPARTYTRANS_PG1 41 rows exporte
. . exporting table W3LABORTRANS 1761 rows exporte
. . exporting table W3LABORTRANS_PG1 1761 rows exporte
. . exporting table W3MATLTRANS_PG1 501 rows exporte
. . exporting table W3RENTTRANS_PG1 103 rows exporte
. . exporting table WFACTION 85 rows exporte
. . exporting table WFACTIONLIST 21 rows exporte
. . exporting table WFASSIGNMENT 25 rows exporte
. . exporting table WFCALLSTACK 0 rows exporte
. . exporting table WFCONDITION 16 rows exporte
. . exporting table WFINPUT 2 rows exporte
. . exporting table WFINSTANCE 0 rows exporte
. . exporting table WFNODE 63 rows exporte
. . exporting table WFNOTIFICATION 0 rows exporte
. . exporting table WFPROCESS 7 rows exporte
. . exporting table WFREVISION 0 rows exporte
. . exporting table WFROLE 4 rows exporte
. . exporting table WFSTART 7 rows exporte
. . exporting table WFSTOP 14 rows exporte
. . exporting table WFSUBPROCESS 0 rows exporte
. . exporting table WFTASK 24 rows exporte
. . exporting table WFTRANSACTION 0 rows exporte
. . exporting table WO 0 rows exporte
. . exporting table WOANCESTOR 435 rows exporte
. . exporting table WOASSIGNMNTPARTY 10 rows exporte
. . exporting table WOASSIGNMNTQUEUE 3 rows exporte
. . exporting table WOGEN 0 rows exporte
. . exporting table WOHAZARD 12 rows exporte
. . exporting table WOHAZARDPREC 7 rows exporte
. . exporting table WOLOCKOUT 8 rows exporte
. . exporting table WOPRECAUTION 7 rows exporte
. . exporting table WOPRITRK 555 rows exporte
. . exporting table WORKORDER 219 rows exporte
. . exporting table WORKORDER1 2246 rows exporte
. . exporting table WORKPERIOD 3146 rows exporte
. . exporting table WORKPRIORITY 5 rows exporte
. . exporting table WORKTYPE 5 rows exporte
. . exporting table WOSAFETYLINK 13 rows exporte
. . exporting table WOSAFETYPLAN 6 rows exporte
. . exporting table WOSCHEDACTIVITY 0 rows exporte
. . exporting table WOSTATUS 237 rows exporte
. . exporting table WOTAGLOCK 8 rows exporte
. . exporting table WOTAGOUT 2 rows exporte
. . exporting table WPEDITSETTING 6 rows exporte
. . exporting table WPLABOR 226 rows exporte
. . exporting table WPMATERIAL 125 rows exporte
. . exporting table WPOPERATION 435 rows exporte
. . exporting table WPTOOL 54 rows exporte
. . exporting table XXLEAVE 1 rows exporte
. . exporting table ZFAFE 857 rows exporte
. . exporting table ZZ_WOJOBPURP 63 rows exporte
. . exporting table ZZ_WOPRIORITY 24 rows exporte
. . exporting table testp 1078 rows exporte
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting snapshots
. exporting snapshot logs
. exporting job queues
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
Aug 20 '07 #1
2 2132
Saii
145 Expert 100+
Are the EXP.exe and oracle version the same?
Aug 20 '07 #2
debasisdas
8,127 Expert 4TB
check for

ORA-00904: invalid column name
the above error
Aug 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Zane Thomas [.NET/C# MVP] | last post: by
2 posts views Thread by Mike Metzger | last post: by
5 posts views Thread by Diffident | last post: by
1 post views Thread by huyuhui | last post: by
27 posts views Thread by Neil | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.