Link to home
Start Free TrialLog in
Avatar of Kamal Agnihotri
Kamal AgnihotriFlag for United States of America

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.


Avatar of Kamal Agnihotri
Kamal Agnihotri
Flag of United States of America image

ASKER

Please help me.
ASKER CERTIFIED SOLUTION
Avatar of GGuzdziol
GGuzdziol
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial