Help with Object Type query please

From: <artmerar_at_gmail.com>
Date: Thu, 26 Jun 2014 08:47:39 -0700 (PDT)
Message-ID: <42001e81-9d4a-4675-bc86-9889cbb0bf06_at_googlegroups.com>

Hi,

We are trying to query some data from a table, with nested tables, over a DB link and are receiving this error:

ORA-21700: object does not exist or is marked for delete

We've read some posts and attempted this solution:

http://en.glufke.net/oracle/viewtopic.php?f=2&t=4128

But no luck there. Here is a test run:

SELECT SYS_OP_GUID() FROM DUAL; SYS_OP_GUID()

---

FC1D2BBEB3DE76B9E0401BAC68066A54 Then, did this in BOTH databases:

CREATE OR REPLACE TYPE test_type oid 'FC1D2BBEB3DE76B9E0401BAC68066A54' AS OBJECT (

 customer_id           NUMBER,
 email                 VARCHAR2(100));

/

CREATE OR REPLACE TYPE test_tab AS TABLE OF test_type;
/

Then did this in the remote database:

CREATE TABLE test
  (id NUMBER,
   test_data TEST_TAB)
NESTED TABLE test_data STORE AS test_data;

SELECT id, t1.customer_id, t1.email FROM test_at_niva.ehs.com, TABLE(test_data) t1;

                                                                    *

ERROR at line 1:
ORA-21700: object does not exist or is marked for delete

Any help? We are on Oracle 10gR2.

Thanks in advance. Received on Thu Jun 26 2014 - 17:47:39 CEST