Maximum number of enabled rows exceeded

From: elziko <elziko_at_NOTSPAMMINGyahoo.co.uk>
Date: Thu, 29 Apr 2004 09:17:44 +0100
Message-ID: <4090c028$0$18120$afc38c87@news.easynet.co.uk>

I have just freshly installed 9i2 Standard. I then created a database and now I'm trying to do a full database import from an 8.1.7 full export.

However, I get an error:

ORA-01925 Maximum of 30 enabled roles exceeded. I have read around on metalink (first time I've used it and I think its pretty clumsy!) and it seems that I have to edit my spfileSID.ora. Inside this file I can find no refrence to the maximum number of roles and it doesn't even look like the sort of file I 'd want to edit by hand!

On Metalink there was someone who mentioned having some GUI for editing this file and setting max_enabled_roles. The thread was closed by Oracle before an answer was given as to what this GUI was.

Can anyone explain to me how to edit this file or where the GUI mentioned can me found?

-- 

Cheers,

elziko

Received on Thu Apr 29 2004 - 03:17:44 CDT