[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crete table for storing BLOB data in a seperate tablespace.

Posted on 2006-05-25
2
Medium Priority
?
551 Views
Last Modified: 2013-12-11
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.


0
Comment
Question by:KamalAgnihotri
2 Comments
 

Author Comment

by:KamalAgnihotri
ID: 16762337
Please help me.
0
 
LVL 14

Accepted Solution

by:
GGuzdziol earned 200 total points
ID: 16766976
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
    )
      LOB(ad_composite, ad_sourcetext, ad_finaltext, ad_fltextn, ad_photo, ad_graphic) STORE AS(TABLESPACE BLOBDATA_1
      STORAGE (INITIAL 100M NEXT 100M)
       CHUNK 24K
       NOCACHE LOGGING);
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question