SQL & PL/SQL

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!

Materialized View on table containing Long datatype

X7C7Apr 5 2009 — edited Apr 5 2009

hi
i need to Create a Materialized View on a table having one column Long(Datatype)
is it possible.

i have one table having a column as long(datatype) on the remote DB , i need to create a Materialized view
in the Local DB, BUT AM GETTING THE FOLLOWING ERROR.

ORA-00997: illegal use of LONG datatype

Can anyone will give Solution for this?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2009

Added on Apr 5 2009

3 comments

1,054 views