Re: Error during full import - maximum enabled rles exceeded

snip
> >My question is, when I created database I never had this error
message,
> >why does the error message show up in import, is it recreating some
> >roles which alreday exist, that is why it is failing.
> >
> >Please clarify.

Sorry prem but you are making me a little nervous about what you are doing and why. Most of the people doing a full import from one database to another database can handle something like exceeding the number of roles.

Do you really need to do a full import? Are you really interested instead of importing some of the data from the other database instead of all of it? Usually full imports are only involved in database migrations. Do you want to do a schema level export import aka fromuser touser? Check out documentation for export and import it is in the utilities manuals.

To answer your question above, no, import is not recreating roles that exist it is attempting to add roles from the other database.

Check all the roles that exist in the other database. Check out all the roles that exist in the database you are attempting to import into. Count how many are in each. Find out the total that you need to support in the database you are importing into. Set the parameter to support that configuration. Received on Sat Jan 15 2005 - 11:34:49 CST