OraFAQ Forum: Server Utilities » Help!Export works with sys but not system

Home » RDBMS Server » Server Utilities » Help!Export works with sys but not system

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

Help!Export works with sys but not system [message #72824]

Mon, 10 November 2003 15:52

sheela
Messages: 66
Registered: March 2002

Member

Hi,
I'm trying to do a full export on oracle 9i. The export works fine with user 'sys' as sysdba, but fails with user 'system' with the following error. This happens even with a simple full export (using interactively) I never had this issue before. Could someone please clarify what the problem is?

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.LT_EXPORT_PKG", line 64
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.system_info_exp
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_METADATA", line 474
ORA-06512: at "SYS.DBMS_METADATA", line 497
ORA-06512: at "SYS.DBMS_METADATA", line 649
ORA-06512: at line 1
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_METADATA", line 474
ORA-06512: at "SYS.DBMS_METADATA", line 497
ORA-06512: at "SYS.DBMS_METADATA", line 649
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

But everything is fine is I use 'sys as sysdba'.

Thanks

Report message to a moderator

More Info [message #72825 is a reply to message #72824]

Mon, 10 November 2003 16:23

sheela
Messages: 66
Registered: March 2002

Member

All packages in sys, system are valid. I tried running catexp.sql again. Doesn't help.

Report message to a moderator

Re: More Info [message #72828 is a reply to message #72825]

Tue, 11 November 2003 05:12

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

Senior Member
Account Moderator

first do this. login as sys and 

GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database; 

then grant exp_full_database to system.
or
GRANT EXECUTE ON sys.lt_export_pkg TO PUBLIC

Report message to a moderator

Re: More Info [message #72829 is a reply to message #72828]

Tue, 11 November 2003 11:12

sheela
Messages: 66
Registered: March 2002

Member

Both of them has been already granted. I even run the catalog.sql and still no change!!!!!!!

Report message to a moderator

Previous Topic:	NT cold backups via "AT"
Next Topic:	creating a flat file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 20:43:31 CST 2024