exp utility - Oracle Database

1 New Member

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 Reply

2280

Saii

145

Recognized Expert New Member

Are the EXP.exe and oracle version the same?

Aug 20 '07 #2

debasisdas

8,127

Recognized Expert Expert

check for

ORA-00904: invalid column name
the above error

Aug 21 '07 #3

Similar topics

1500

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

29540

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

10535

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

2289

"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

5371

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

5889

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

2123

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

1453

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

2127

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

2008

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

7027

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6899

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7067

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6847

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4463

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2970

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1288

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

555

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

166

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General