OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Error [message #137394]

Thu, 15 September 2005 01:36

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hello Gurus,

I am taking a schema export only and not the data from the database. After the tables are exported it is giving error for which i am attaching the log file.

The script i am using to take backup is :-

exp system/system@idbr1arrow file=arrow150920051830.dmp log=arrow150920051830.log grants=y owner=arrow rows=n

Can somebody tell me why the error is coming as i dont have any idea how to solve this.

Thanks in advance.

Milind.

Attachment: arrow150920051830.log
(Size: 1.25KB, Downloaded 1188 times)

Report message to a moderator

Re: Export Error [message #137414 is a reply to message #137394]

Thu, 15 September 2005 02:35

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi milind , log file is not complete . can u post it again.

This is what i got from ur log file

 
 onnected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ARROW 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ARROW 
About to export ARROW's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ARROW's tables via Conventional Path ...
. . exporting table               CT1_STATS_BACKUP
. . exporting table          MICROSOFTDTPROPERTIES
. . exporting table                           NODE
. . exporting table                          NODE1
. . exporting table                     PLAN_TABLE
. . exporting table                   TAFFILIATION
. . exporting table             TAFFILIATION_ALERT
. . exporting table       TAFFL_CUST_APP_MAP_USAGE
. . exporting table               TAFFL_MEMBERSHIP
. . exporting table                         TAGENT

cant see any error.

regards,
tarun

Report message to a moderator

Re: Export Error [message #137431 is a reply to message #137414]

Thu, 15 September 2005 03:04

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hi Tarun,

Thanks for your response. This is the error:-

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ARROW
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ARROW
About to export ARROW's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ARROW's tables via Conventional Path ...
. . exporting table CT1_STATS_BACKUP
. . exporting table MICROSOFTDTPROPERTIES
. . exporting table NODE
. . exporting table NODE1
. . exporting table PLAN_TABLE
. . exporting table TAFFILIATION
. . exporting table TAFFILIATION_ALERT
. . exporting table TAFFL_CUST_APP_MAP_USAGE
. . exporting table TAFFL_MEMBERSHIP
. . exporting table TAGENT
. . exporting table TALERT
. . exporting table TAPPLICATION_ACCESS
. . exporting table TAPPLICATION_ACCESS_AUDIT
. . exporting table TAPP_AUDIT
. . exporting table TASSM_NAME_EXPRN_SCHEDULE
. . exporting table TBUSINESS_NAME
. . exporting table TBUSINESS_NAME_COMMENT
. . exporting table TCOMMENT
. . exporting table TCOMM_TRANSMITTAL
. . exporting table TCOMM_WORKSHEET
. . exporting table TCUSTOMER_APPLICATION_MAP
. . exporting table TCUSTOMER_APP_MAP_AUDIT
. . exporting table TDEFAULT_AGENT
. . exporting table TDI
. . exporting table TDIRECTOR
. . exporting table TDI_HISTORY
. . exporting table TDI_PARTICIPANT
. . exporting table TDI_TEMP
. . exporting table TDI_USAGE
. . exporting table TDI_USAGE_HISTORY
. . exporting table TDI_USAGE_HISTORY_COMMENT
. . exporting table TDOCS
. . exporting table TENTITY
. . exporting table TENTITY_ALERT
. . exporting table TENTITY_COMMENT
. . exporting table TENTITY_CUST_APP_MAP_USAGE
. . exporting table TENTITY_DI_USAGE
. . exporting table TENTITY_SOURCE
. . exporting table TERROR_LOG
. . exporting table TEST_SOP_DATA
. . exporting table TEST_XML
. . exporting table TEVENT
. . exporting table TEVENT_SOURCE
. . exporting table TFEDEX_ACCT_METER_LOOKUP
. . exporting table TFEDEX_COUNTRY
. . exporting table TFEDEX_PACKAGE
. . exporting table TFEDEX_PKG_CONTENT
. . exporting table TGMSOP_EMAIL_HISTORY
. . exporting table TGMSOP_LAWFIRMS
. . exporting table TLOOKUP
. . exporting table TMESSAGE_QUEUE
. . exporting table TNAME_QUALIFICATION
. . exporting table TOBJECT_TYPE
. . exporting table TPART_ASSIGNMENT
. . exporting table TPART_ASSIGN_AUDIT
. . exporting table TPERFORMANCE
. . exporting table TREPRESENTATION
. . exporting table TREP_HISTORY
. . exporting table TREP_SERVICE_TYPE
. . exporting table TREP_SOURCE
. . exporting table TSECURITY_ROLE
. . exporting table TSECURITY_ROLE_GRANT
. . exporting table TSECURITY_ROLE_PERMISSION
. . exporting table TSOP_ACTION_ITEM
. . exporting table TSOP_CASE
. . exporting table TSOP_COMMENT
. . exporting table TSOP_CONTACT_INFO
. . exporting table TSOP_RECIPIENT_INFO
. . exporting table TSOP_REDIRECT_RECIPIENT
. . exporting table TSOP_REDIRECT_REQUEST
. . exporting table TSOP_TEXT_LOOKUP
. . exporting table TSOP_TRANSMITTAL
. . exporting table TSOP_WORKSHEET
. . exporting table TSTATE_ID_VALIDATION
. . exporting table TSUBGROUP
. . exporting table TSUBGROUP_ALERT
. . exporting table TSUBGROUP_DI_USAGE
. . exporting table TSUBGROUP_MEMBERSHIP
. . exporting table TUSOP_CHANNEL
. . exporting table TUSOP_COMMENT
. . exporting table TUSOP_CONTACT_INFO
. . exporting table TUSOP_PARTNER
. . exporting table TUSOP_SUBSCRIPTION
. exporting synonyms
. exporting views
EXP-00056: ORACLE error 904 encountered
ORA-00904: "UNDERCLAUSE": invalid identifier
EXP-00000: Export terminated unsuccessfully

Please help me if you have any clue about this. And another thing is it possible that this error can occur due to some invalid views or procedures.

thanks in advance.

Milind.

Report message to a moderator

Re: Export Error [message #137436 is a reply to message #137431]

Thu, 15 September 2005 04:30

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Report message to a moderator

Re: Export Error [message #137441 is a reply to message #137436]

Thu, 15 September 2005 04:36

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hi Mahesh,

Thanks for your response. But, the problem is solved.

There were some views which were having status invalid. So, I compiled them and the problem got solved.

Thanks all of you for helping me.

Milind.

Report message to a moderator

Previous Topic:	Increasing Buffer size while import is running
Next Topic:	Imp 00069 and Imp 00021

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 21:42:09 CDT 2024