Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


DBMS_METADATA_UTIL.LONG2VARCHAR


Hi all  I create a dblink on DB1, and I create a MV on DB2 based on the first dblink My problem is when I create a materialized view for a table containning a column with LONG type. I use DBMS_METADATA_UTIL.LONG2VARCHAR. But I get a MV with a empty column. The same result when I use DBMS_METADATA_UTIL.LONG2CLOB. Is there a solution for this.  Thanks in advance.

The LONG data type has been deprecated. Why are you trying to use it for new development?

I Inherit a table with a column LONG data type. I have to create a meterialized view on an other database based on this table. How I can resolve this?


Related Links

is this the backup strategy easily recoverable??
Oracle Troubleshooting Database Backup
restore from archive
TNS-12543: TNS:destination host unreachable
high redo generation causing outage to Application
ORA-12012: ORA-01438:
create tablespace error
11gR2 failed web connection
Quicker and cleaner way?
Firewall setting for Oracle 8i application
grant select any table
Cannot resize a data file.
Re: I am unable to start the service
Why we need two Joins (Left and Right)
Create table error
How to find out all that is running from a certain ORACLE_HOME?