-
ora-01003 on export in 9.2 database
. . exporting table ENTITY_MASTER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table FEE_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table FIELD_MULTIPLES
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table GEN_LABELS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table GEN_LATER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table GRAPH_COUNT
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table GROUP_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table GROUP_TIME
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table IMAGE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table INSURANCE_HIST
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LAST_SEQ
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LIABILTY_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LICENSE_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LOG_COLUMN
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LOG_PRIMKEY
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LOG_TABLE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LTR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LTR_MASTER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table MASTER_CRED
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table MODALITY_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table PEND_MAINTENANCE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table PEND_PROCESS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table POPULATION_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table PRIVLIEGE_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table PRIV_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table PRIV_MASTER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QA_INDICATOR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QA_PEER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QA_PEER_INQUIRY
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QA_REVIEW
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_FORM_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_FORM_HEADER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_GROUP
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_INDICATOR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QI_PRACTITIONER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table QPRAC_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table REFERANCE_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table RENEW_PROCESS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table REPORTS_GEN
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table REPORTS_GEN_HDR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table RUN_PROGRAM
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table STATUS_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_CAPACITY
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_CHART_DET
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_CHART_HDR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_FORM_SUM
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_GROUP
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_GROUP_ANS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_PRAC
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SURVEY_PRAC_ANS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SYS_LOOKUPS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SYS_OPTIONS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table SYS_PROFILE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table TABLE_ADD_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table TABLE_ADD_MASTER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table TEXT_LINES
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table TICKLER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table USERDEF_DETAIL
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table USERDEF_MASTER
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table USER_PROFILE_VIP
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table USER_QUERY_DET
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table USER_QUERY_HDR
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table ZIP_CODE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. about to export MYRA's tables via Conventional Path ...
. about to export HR8's tables via Conventional Path ...
. . exporting table COUNTRIES
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table DEPARTMENTS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table EMPLOYEES
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table JOBS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table JOB_HISTORY
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table LOCATIONS
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table REGIONS
EXP-00008: ORACLE error 1003 encountered
I am getting this error export a 9.2 database - what is this error?
Is some patch missing?
ORA-01003: no statement parsed
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 22:
PLS-00201: identifier 'SYS.DBMS_DDL' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
EXP-00000: Export terminated unsuccessfully
-
Actually you should be re-running catalog.sql which will run catexp.sql. The errors indicate that the views needed for export have not been created successfully.
If you continue to generate errors, please post back with information on any upgrades that may have been done .There may have been an upgrade script that wasn't run successfully.
If you export from Oracle9i using oracle8i client,The case also may occur.
Last edited by qiuyb; 08-20-2003 at 11:55 PM.
Oracle Is My all.
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
|