MATERIALIZED VIEW WITH NESTED TABLE [message #71017] |
Tue, 27 August 2002 04:49 |
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 |
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;
|
|
|