Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-22992: cannot use LOB locators selected from remote tables

user500315Jan 29 2007 — edited Feb 8 2007

Hello pals, i'm trying to create a materialized view on a remote database, both on 10G R2.2, the table i'm trying to replicate has a BLOB column and i receive the error ORA-22992. The replication i need to do is in FAST mode, but i can't even query the table in the remote database: select * from table@dblink.
Can you help me please with this matter?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2007

Added on Jan 29 2007

#database-key-features, #replication

2 comments

82,775 views