Home » Server Options » Replication » Materialized view with CLOB/BLOB
Materialized view with CLOB/BLOB [message #218586] Thu, 08 February 2007 17:30
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
SQL> desc test_img
Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 NOT NULL VARCHAR2(15)
PHOTO1 BLOB
PHOTO2 BLOB
MINUTIAE BLOB
LFQUALITY NUMBER(4)


SQL> create materialized view TEST_IMG_MV
2 TABLESPACE USERS
3 BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND
4 AS SELECT * from TEST_IMG LOB(PHOTO1) STORE AS (TABLESPACE TEST_T01 STORAGE (INITIAL 6144 NEXT 6144)
5 CHUNK 4000
6 NOCHACHE LOGGING);
AS SELECT * from TEST_IMG LOB(PHOTO1) STORE AS (TABLESPACE TEST_T01 STORAGE (INITIAL 6144 NEXT 6144)
*
ERROR at line 4:
ORA-00933: SQL command not properly ended

What is the correct syntax?

create table is fine. But mat view will work, same table space it will look ( if i used diff one for LOB column in table mat view also look same tablespace or not?

Please helpe me with correct syntax. no where i can find out example with proper syntax..
Previous Topic: Materialize view complete refresh
Next Topic: replication problem
Goto Forum:
  


Current Time: Fri Mar 29 04:21:02 CDT 2024