Home » Server Options » Replication » MATERIALIZED VIEW WITH NESTED TABLE
MATERIALIZED VIEW WITH NESTED TABLE [message #71017] Tue, 27 August 2002 04:49 Go to next message
ritesh kumar tiwary
Messages: 7
Registered: August 2002
Junior Member
sir,
is it posible to make MATERIALIZED VIEW with nested table from deferent database. it is send message.

source database name : - play

now i have written script in target database name backup

CREATE MATERIALIZED VIEW CP_UPDATES_EDIT
2 STORAGE (INITIAL 100K NEXT 100K
3 PCTINCREASE 0)
4 TABLESPACE SNAPS
5 REFRESH COMPLETE
6 START WITH SYSDATE NEXT SYSDATE +1/24/60/60
7 WITH ROWID
8 AS
9 SELECT *FROM CP_UPDATES_EDIT @PLAY;
ERROR at line 9:
ORA-22804: remote operations not permitted on object tables or user-defined type columns

please send message immediately .
regards
ritesh kumar tiwary
Re: MATERIALIZED VIEW WITH NESTED TABLE [message #71704 is a reply to message #71017] Tue, 24 December 2002 02:57 Go to previous message
Shalini singh
Messages: 11
Registered: September 2002
Junior Member
first create database link with the following syntax

create database link play
connect to <user name> identified by password
using 'play';

then check if it is successfully created in user_db_links table

then write your sql

CREATE materialized view CP_UPDATES_EDIT
2 STORAGE (INITIAL 100K NEXT 100K
3 PCTINCREASE 0)
4 TABLESPACE SNAPS
5 REFRESH COMPLETE
6 START WITH SYSDATE NEXT SYSDATE +1/24/60/60
7 WITH ROWID
8 AS
9 SELECT *FROM <username>.CP_UPDATES_EDIT @PLAY;
Previous Topic: how to replicate some table from one database to remote database
Next Topic: Is it possible to up the Server Using Datafiles
Goto Forum:
  


Current Time: Fri Mar 29 10:32:27 CDT 2024