| Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178930] |
Fri, 23 June 2006 07:40  |
n_rajasekhar
Messages: 2
Registered: June 2006
|
Junior Member |
|
|
Hi,
When i am importing data, i have got the following error and i couldn't complete the import.
The total # of enabled roles for one user is 487.
init.ora file of my database not allowing me to increase the max_enabled_roles more than 148.
============
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by DIMENSION, not by you
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
. importing DIMENSION's objects into DIMENSION
. importing SUPPORT's objects into SUPPORT
. importing UPDATESHELFNAME's objects into UPDATESHELFNAME
. importing NDCIF's objects into NDCIF
. importing NDBIF's objects into NDBIF
. importing DIMULL's objects into DIMULL
. importing REC's objects into REC
IMP-00003: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded
IMP-00003: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded
IMP-00000: Import terminated unsuccessfully
==================================
Please help me how to rectify this error.
Thanks and regards,
N Raja Sekhar.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178967 is a reply to message #178950] |
Fri, 23 June 2006 11:31  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Whatever you do, never ever edit the dmp file. You may corrupt it.
Seems there are many circular references in the schema.
The only way i can reproduce your case by Exporting as SYS. Else the export will error about the same (max enabled roles exceded).
Try this.
Export only the schema you want (logged in as sys).
Import to the target database using fromuser/touser option (logged in as sys).
I can successfully import the schema.
So try exporting and import the schemas one-at-a-time.
-- here TEST the schema having around 300 roles granted to it.
oracle@mutation#exp scott/tiger owner=test
Export: Release 9.2.0.4.0 - Production on Fri Jun 23 12:21:09 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded
EXP-00000: Export terminated unsuccessfully
--- export only the required user logged in as SYSDBA
oracle@mutation#exp '"sys/sys as sysdba"' owner=test
Export: Release 9.2.0.4.0 - Production on Fri Jun 23 12:22:02 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
. . exporting table EMP 458752 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
--import as sysdba
oracle@mutation#imp '"sys/xxxxx@lawd as sysdba"' fromuser=test touser=scott
Import: Release 9.2.0.4.0 - Production on Fri Jun 23 12:28:33 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing TEST's objects into SCOTT
. . importing table "EMP" 458752 rows imported
Import terminated successfully without warnings.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
