ORA-02251: subquery not allowed here

ORA-02251
ORA-02251: subquery not allowed here
Cause: Subquery is not allowed here in the statement.
Action: Remove the subquery from the statement.
More details : Viste http://www.high-oracle.com/ora-02251/
More details : Viste http://www.high-oracle.com/ora-02251/
-------------------------------------------------------

-------------------------------------------------------
Viste our Support Blog : http://updatefun.blogspot.fr/
Viste our Support Blog : http://oracleerrormsgs.blogspot.fr/
Viste our Support Blog : http://oracleerror1.blogspot.fr/
Viste our Support Blog : http://supports-oracle.blogspot.com/
Viste our Support Blog : http://oracleerrorcodelist.blogspot.fr/
Viste our Support Blog : http://all-dba-support.blogspot.fr/
Viste our Support Blog : http://my-support-oracle.blogspot.fr/
-------------------------------------------------------

Your source for help on all Oracle database error codes :
------------------------
ORA-12088: cannot online redefine table ""."" with unsupported datatype
ORA-25308: AQ canonicalization event
ORA-03100: communication area cannot be allocated; insufficient memory
ORA-30005: missing or invalid WAIT interval
ORA-31433: subscriber view does not exist
ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is
ORA-08197: Flashback Table operation is not supported on clustered
ORA-30436: unable to open named pipe ''
ORA-02051: another session in same transaction failed
TNSNAV.ORA
ORA-24067: exceeded maximum number of subscribers for queue
ORA-14518: partition contains rows corresponding to values being
ORA-14071: invalid option for an index used to enforce a constraint
ORA-01099: cannot mount database in SHARED mode if started in single
ORA-02435: cannot disable unique() - unique key not defined for table
ORA-00278: log file '' no longer needed for this recovery
ORA-01908: EXISTS keyword expected
ORA-30515: suspend triggers cannot have BEFORE type
ORA-26729: event for configuring STREAMS apply destination object cache
ORA-01355: logminer tablespace change in progress
-------------------------------------------------------
Error Oracle : ora-22925 http://www.high-oracle.com/ora-22925/
Error Oracle : ora-08319 http://www.high-oracle.com/ora-08319/
Error Oracle : ora-06918 http://www.high-oracle.com/ora-06918/
Error Oracle : ora-19505 http://www.high-oracle.com/ora-19505/
Error Oracle : ora-13752 http://www.high-oracle.com/ora-13752/
Error Oracle : ora-14101 http://www.high-oracle.com/ora-14101/
Error Oracle : ora-02179 http://www.high-oracle.com/ora-02179/
Error Oracle : ora-33054 http://www.high-oracle.com/ora-33054/
Error Oracle : ora-24360 http://www.high-oracle.com/ora-24360/
Error Oracle : ora-07508 http://www.high-oracle.com/ora-07508/
Error Oracle : ora-36962 http://www.high-oracle.com/ora-36962/
Error Oracle : ora-01224 http://www.high-oracle.com/ora-01224/
Error Oracle : ora-01170 http://www.high-oracle.com/ora-01170/
Error Oracle : ora-00927 http://www.high-oracle.com/ora-00927/
Error Oracle : ora-37132 http://www.high-oracle.com/ora-37132/
Error Oracle : ora-24099 http://www.high-oracle.com/ora-24099/
Error Oracle : ora-02005 http://www.high-oracle.com/ora-02005/
Error Oracle : ora-02849 http://www.high-oracle.com/ora-02849/
Error Oracle : ora-12322 http://www.high-oracle.com/ora-12322/
Error Oracle : ora-02466 http://www.high-oracle.com/ora-02466/
-------------------------------------------------------
Viste our Support Blog : http://updatefun.blogspot.fr/
Viste our Support Blog : http://oracleerrormsgs.blogspot.fr/
Viste our Support Blog : http://oracleerror1.blogspot.fr/
Viste our Support Blog : http://oracleerrorcodelist.blogspot.fr/
Viste our Support Blog : http://all-dba-support.blogspot.fr/
Viste our Support Blog : http://my-support-oracle.blogspot.fr/
-------------------------------------------------------