Kamal Agnihotri
asked on
Crete table for storing BLOB data in a seperate tablespace.
I am trying to creat a table which will store the Blob data. The Following tablespae was created Successfully.
SQL> CREATE TABLESPACE BLOBDATA_1 DATAFILE
2 'C:\ORACLEDATA\BLOBDATA_1. DBF'
3 SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M
4 LOGGING
5 ONLINE
6 PERMANENT
7 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M
8 BLOCKSIZE 8K
9 SEGMENT SPACE MANAGEMENT AUTO
10 FLASHBACK ON;
Tablespace created.
Then I try to create this table and get an error message. The error message is boelow.
CREATE TABLE print_media_new
( product_id NUMBER(6)
, ad_id NUMBER(6)
, ad_composite BLOB
, ad_sourcetext CLOB
, ad_finaltext CLOB
, ad_fltextn NCLOB
, ad_photo BLOB
, ad_graphic BFILE
, press_release LONG
)
STORE AS(TABLESPACE BLOBDATA_1
STORAGE (INITIAL 100M NEXT 100M)
CHUNK 24K
NOCACHE LOGGING);
Error Message:
STORE AS(TABLESPACE BLOBDATA_1
*
ERROR at line 12:
ORA-00922: missing or invalid option
****************
What am I doing wrong. How can I fix this Create table statement.
SQL> CREATE TABLESPACE BLOBDATA_1 DATAFILE
2 'C:\ORACLEDATA\BLOBDATA_1.
3 SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M
4 LOGGING
5 ONLINE
6 PERMANENT
7 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M
8 BLOCKSIZE 8K
9 SEGMENT SPACE MANAGEMENT AUTO
10 FLASHBACK ON;
Tablespace created.
Then I try to create this table and get an error message. The error message is boelow.
CREATE TABLE print_media_new
( product_id NUMBER(6)
, ad_id NUMBER(6)
, ad_composite BLOB
, ad_sourcetext CLOB
, ad_finaltext CLOB
, ad_fltextn NCLOB
, ad_photo BLOB
, ad_graphic BFILE
, press_release LONG
)
STORE AS(TABLESPACE BLOBDATA_1
STORAGE (INITIAL 100M NEXT 100M)
CHUNK 24K
NOCACHE LOGGING);
Error Message:
STORE AS(TABLESPACE BLOBDATA_1
*
ERROR at line 12:
ORA-00922: missing or invalid option
****************
What am I doing wrong. How can I fix this Create table statement.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER