I would like to EXPORT the DATABASE INSTANCE Named "GATES" and execute
following:
-----------------------------------------------------------
../exp
Username: system
Password: ****
Export File: expgates.dat
Users
Grants: yes
Table Data: yes
Compress Extents: yes
Exporet done is US7ASCII and AL16UTF16 NCHAR. Server uses
WE8ISO8859P1
User to be exported: BILL
.......
and my output console shows following:
EXP-00091: Exporting questionable staticis
.. exporting synonuyms
.. exporting triggers
EXP-00056: ORACLE error 6550 encountered
ORA-06550: Line 1, column 26:
PLS-00201: identified 'XDB.DBMS_XDBUT IL_INT' must be declared
.....
EXP-00000: ,Expoert terminated unsuccessfully
--------------------------------------------------------------------
Any hints or suggestions or related information on above errors would
be greatly appreciated.
I read the EXPORT Oracle DOcs and it said to FIRST RUN "catexp.sql " OR
"catalog.sq l" scripts.....I executed those but still in vain....
wonder why..... It also says to check the privileges....a nd the user
"SYSTEM" had "EXP_FULL_DATAB ASE" role enabled
Thanks!
following:
-----------------------------------------------------------
../exp
Username: system
Password: ****
Export File: expgates.dat
Users
Grants: yes
Table Data: yes
Compress Extents: yes
Exporet done is US7ASCII and AL16UTF16 NCHAR. Server uses
WE8ISO8859P1
User to be exported: BILL
.......
and my output console shows following:
EXP-00091: Exporting questionable staticis
.. exporting synonuyms
.. exporting triggers
EXP-00056: ORACLE error 6550 encountered
ORA-06550: Line 1, column 26:
PLS-00201: identified 'XDB.DBMS_XDBUT IL_INT' must be declared
.....
EXP-00000: ,Expoert terminated unsuccessfully
--------------------------------------------------------------------
Any hints or suggestions or related information on above errors would
be greatly appreciated.
I read the EXPORT Oracle DOcs and it said to FIRST RUN "catexp.sql " OR
"catalog.sq l" scripts.....I executed those but still in vain....
wonder why..... It also says to check the privileges....a nd the user
"SYSTEM" had "EXP_FULL_DATAB ASE" role enabled
Thanks!