Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-02022: remote statement has unoptimized view with remote
object



ORA-02022: remote statement has unoptimized view with remote object..

Answer / guest

Cause: The local view is unoptimized and contains references
to objects at the remote database and the statement must be
executed at the remote database.

Action: Create a similar view on the remote database and
modify the violating view in the SQL statement with the new
view@remote.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24338: statement handle not executed

1 Answers  


ORA-27091: unable to queue I/O

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  


ORA-00602: internal programming exception

1 Answers  


ORA-25009: Nested table clause allowed only for INSTEAD OF triggers

1 Answers  


DRG-11726: phrase is not a preferred term

1 Answers  


ORA-16138: end of log stream not received from primary

1 Answers  


ORA-13414: invalid pyramid parameter

1 Answers  


TNS-00220: Pump Breakdown --------------

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  


ORA-06044: NETDNT: connect failed, byte count quota exceeded

1 Answers  


ORA-25965: fact table must be included in the from clause

1 Answers  


Categories