Database Administration (MOSC)

MOSC Banner

Create view of Remote table with CLOB column

edited May 6, 2010 9:31AM in Database Administration (MOSC) 5 commentsAnswered
 We recently migrated from 9i to 10g and a view (from table on a remote database which includes a clob column) we had isn't working in 10g; returns error:  ORA-22992: cannot use LOB locators selected from remote tables

After trying different ways of creating the view, (including using to_char() and NVL2() on the clob column) I created a materialized view which pulled the data no problem.

I really want to create a simple view of this table since the data really needs to be as real-time as possible. 

Any suggestions?

Thanks,

Faith

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center