Answer Posted / premalingam

1) Export the snapshots and then do a manual purge
2) Ignore this error Else let oracle do the job. Did you
know the MMON does auto maintenance of sysaux storage
management. Look below as taken from alert log.

ORA-1688: unable to extend table SYS.WRH$_LATCH_CHILDREN
partition WRH$_LATCH__2530202403_28403 by 128 in tablespace
SYSAUX
ORA-1688: unable to extend table SYS.WRH$_LATCH_CHILDREN
partition WRH$_LATCH__2530202403_28403 by 128 in tablespace
SYSAUX
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (28078) and older
Mon Feb 15 06:02:42 2010

3) Increase space of sysaux data file or add another file.
4) Oracle provides utlsyxsz.sql file to help calculate
approx the size required by sysaux. Find out the space and
add another 25% extra on top of it to be sure for a good
measure.
5) It might be possible Disable alerts due to sysaux space
warnings .

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2712

---

ORA-26029: index string.string partition string initially in unusable state

2161

---

NZE-28868: Peer certificate chain check failed.

2811

---

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

2812

---

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2723

---

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

6752

---

ORA-26095: unprocessed stream data exists

3588

---

IMG-02003: 2FF03 - incorrect color histogram feature specification

1716

---

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

1973

---

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2249

---

ORA-26094: stream format error: input column overflow

2817

---

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.............

2808

---

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

3867

---

RMAN-05017: no copy of datafile number found to recover

2414

---

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3182

---