Home » SQL & PL/SQL » SQL & PL/SQL » DATABSE_LINK_ERROR (10.2.0.4 and 11.2.0.4)
DATABSE_LINK_ERROR [message #570552] Mon, 12 November 2012 04:08 Go to next message
tabj
Messages: 20
Registered: June 2012
Junior Member
Hi all,

I have two databases. Emample database A(11.2.0.4) , database B(10.2.0.4).

while inserting object data from database A to database B i am getting below error.

ORA-22804: remote operations not permitted on object tables or user-defined type columns.

while updating i am not getting any error.

please help me on this.

regards,
tabj
Re: DATABSE_LINK_ERROR [message #570553 is a reply to message #570552] Mon, 12 November 2012 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-22804: remote operations not permitted on object tables or user-defined type columns
 *Cause:  An attempt was made to perform queries or DML operations on
          remote object
          tables or on remote table columns whose type is one of object,
          REF, nested table or VARRAY.


As I said in your previous topics, on which by the way we are still waiting you feedback:

Michel Cadot wrote on Fri, 05 October 2012 17:19
Too few information...

So, Use SQL*Plus and copy and paste your session, the WHOLE session.

Michel Cadot wrote on Wed, 04 July 2012 08:17
Also, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
And always post your Oracle version, with 4 decimals.
...


The real version, I don't think 11.2.0.4 exists.

Regards
Michel



[Updated on: Mon, 12 November 2012 04:17]

Report message to a moderator

Re: DATABSE_LINK_ERROR [message #570554 is a reply to message #570553] Mon, 12 November 2012 04:21 Go to previous messageGo to next message
tabj
Messages: 20
Registered: June 2012
Junior Member
Hi ,

i am sorry, the version is 11.2.0.2.

regards,
tabj
Re: DATABSE_LINK_ERROR [message #570556 is a reply to message #570554] Mon, 12 November 2012 04:32 Go to previous message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PK now the other points.

Regards
Michel
Previous Topic: replace with the first occurence in the string
Next Topic: date conversion
Goto Forum:
  


Current Time: Fri Aug 01 21:35:33 CDT 2014

Total time taken to generate the page: 0.04893 seconds