Re: Migration result exceeds max roles

From: Alistair Thomson <alistair_at_despammed.com>
Date: Tue, 21 Jan 2003 09:41:16 -0000
Message-ID: <b0j4jp$lre$1$830fa7a5@news.demon.co.uk>

Set the following in the init.ora file and restart your oracle database and begin the migration again.

max_enabled_roles = 100

Hope it helps

Alistair

"Art Krumsee" <akrumsee_at_columbus.rr.com> wrote in message news:vO7X9.97583$GF.25797412_at_twister.columbus.rr.com...
> I'm porting a relatively simple SQL Server application to Oracle and hoped
> to use Migration workbench to help me get started. When I ran workbench
> against the fairly simple database (half a dozen tables, a dozen stored
> procedures) it appeared to run cleanly but when I then went to log into my
> database I got a error message reporting that I'd exceeded the maximimum
of
> 30 roles. As someone relatively new to Oracle and just beginning to find
my
> way around, I'm not sure how to get past this limitation.
>
> Art
>
>
Received on Tue Jan 21 2003 - 03:41:16 CST