| 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..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
