exp utility - Oracle Database

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

Subscribe Post Reply

2229

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

Similar topics

Swen E-Mail Zapper Utility

by: Zane Thomas [.NET/C# MVP] | last post by:

If, like me, your connection is being swamped downloading copies of the Swen Worm and bounce messages, you might find the utility I wrote today useful. Source for the utility is distributed with...

.NET Framework

SQL Server Network Utility - where is it?

by: stefanPL | last post by:

Hello, I have SQL Server 2000 Developer Edition. Where is SQL Server Network Utility? In Start menu SQL server group I have only Client Network Utility :| Is it a command line tool or sth? How...

Microsoft SQL Server

Access2000 can't find Utility.mda file

by: Mike Metzger | last post by:

I've been running an Access2000 database for a couple years on a Win2k machine fine. We tried to copy the database over to another machine that already had Access2000 installed. When we tried to...

Microsoft Access / VBA

"Page" class and utility class

by: Diffident | last post by:

Hello All, I have written a webform which is by default derived from "Page" class. I have coded another utility class with few methods and an object of this class is instantiated from the webfom...

ASP.NET

Microsoft wsdl Utility fails when multiple <schema> tags reference same targetNamespace

by: Jeff | last post by:

We are using .Net and the wsdl Utility to generate proxies to consume web services built using the BEA toolset. The data architects on the BEA side create XML schemas with various entities in...

.NET Framework

When will LOAD utility check consistaint

by: huyuhui | last post by:

The following is a question of LOAD utility. Question: How does the DB2 enforce table check constraints for data added to table with the LOAD utility? A. With the BUILD phase of LOAD B. With the...

DB2 Database

Utility for Table Schemas

by: Neil | last post by:

Anyone have a recommendation for a good inexpensive or free utility for developing table schemas.

Microsoft Access / VBA

Utility to Estimate Object Size?

by: TC | last post by:

Years ago, I found a utility which estimated the size of all objects in an .mdb file and presented the results in a nicely-formatted grid. I no longer have that utility, and I can't find it...

Microsoft Access / VBA

Passing more than one variable from utility function

by: Kurt Jakobsen | last post by:

Hello, I have a utility class that do some db queries that are used by independent pages. From one of the utility functions I would like to return variables back to the aspx page. In old C this...

.NET Framework

Setting a Varing Directory Structure for Static Utility Files

by: hsheboul | last post by:

Thanks to Markus for pointing me to all the Apache stuff http://bytes.com/topic/html-css/answers/876342-automating-web-site-template My Web site is hosted on a shared Linux hosting, that runs the...

Apache Web Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...

PHP

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General

Problems to capture mouse_down event on a control within a form with lots of controls

by: Ricardo de Mila | last post by:

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

Microsoft Access / VBA

Datasheet Form, iterate through records

by: Johno34 | last post by:

I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...

Microsoft Access / VBA

Hide Labels depending on checkbox value

by: ezappsrUS | last post by:

Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...

Microsoft Access / VBA

hello, Is there code or static lib for hook swapchain present?

by: jack2019x | last post by:

hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

C / C++