Answer Posted / cvbb

At first time you can think about max_enabled_roles
parameter but max_enabled_roles parameter has nothing to do
if you enable 148 user-defined roles.

In fact this parameter is deprecated. It is retained for
backward compatibility only. You can see this parameter
settings by,

SQL> show parameter max_enable

NAME TYPE VALUE
———————————— ——————————— ——————————
max_enabled_roles integer 150

Though this parameter is set to 150 and you have enabled 148
user defined roles but additional user-defined roles can’t
be enabled because of the actual number of roles that users
can enable is 148. So max_enabled_roles is 2 plus 148,
because each user has two additional roles, PUBLIC and the
user’s own role.

As there is limit to 148 so you have to disable fewer roles
or drop some roles and reorganize your database role policy.

You can enable or disable roles by using the SET ROLE
statement for your current session.

If you want to enable all roles except manager and clerk
role then use,

SET ROLE ALL EXCEPT manager, clerk;

Remember roles listed in the EXCEPT clause must be roles
granted directly to you. They cannot be roles granted to you
through other roles.

NZE-28868: Peer certificate chain check failed.

2488

---

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2557

---

ORA-26095: unprocessed stream data exists

3265

---

ORA-26027: unique index string.string partition string initially in unusable state

6499

---

ORA-26094: stream format error: input column overflow

2563

---

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3123

---

ORA-26030: index string.string had string partitions made unusable due to:

1725

---

ORA-26076: cannot set or reset value after direct path structure is allocated

1688

---

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2527

---

ORA-26028: index string.string initially in unusable state

3627

---

NZE-28890: Entrust Login Failed

1604

---

ORA-26079: file "string" is not part of table string.string

1711

---

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2468

---

ORA-16626: failed to enable specified object

1990

---

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1410

---