Re: export/import from 8.1.6.1 to 8.1.6.1 error

Sounds like the user that was exported had grants to another user or to a role called MDSYS which doesn't exist on the importing database. It looks also, like the problem is in the Advanced Queuing system in 816 - do you have this option on the system being imported into ?

Did the import complete with ERRORS or just with WARNINGS (message at the end) - if only warnings, check the log file for anything else that may need to be dealt with, and 'ignore' these messages show because you don't have advanced queueing or the user/role MDSYS is not needed on the importing system ; or

create a user or role called MDSYS and try again; or

if no grants etc are required from the user being imported to other users/roles then specify grants=no on the import command line. But this will stop ANY grants coming through - which may not be what you require.

HTH. Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

-----Original Message-----
From: jimmyn1_at_aol.com (JimmyN1) [mailto:jimmyn1_at_aol.com] Posted At: Saturday, April 21, 2001 7:55 PM Posted To: server
Conversation: export/import from 8.1.6.1 to 8.1.6.1 error Subject: Re: export/import from 8.1.6.1 to 8.1.6.1 error

Sorry, here is the error:

IMP-00017: following statement failed with ORACLE error 1917:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','MDSYS',FALSE);"
"COMMIT; END;"

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MDSYS' does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 0
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3010
ORA-06512: at "SYS.DBMS_AQADM", line 437
ORA-06512: at line 2