Home > Enterprise >  Oracle database 21c Express: blob store as product_image_lob_seg syntax incorrect, how to fix?
Oracle database 21c Express: blob store as product_image_lob_seg syntax incorrect, how to fix?

Time:09-01

I am using Oracle

Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

I am reading book Murach's Oracle (old version of Oracle database) enter image description here

I practice

CREATE BIGFILE TABLESPACE bigtbs_01
  DATAFILE 'bigtbs_f1.dat'
  SIZE 20M AUTOEXTEND ON;

CREATE table product_images
(
    product_id    number primary key,
    product_image blob
) tablespace bigtbs_01 lob (product_image)
    store as product_image_lob_seg
(
    tablespace bigtbs_01
    chunk 32768
    disable storage in row
    cache reads logging
    pctversion 20
);

enter image description here

The error syntax at store as product_image_lob_seg , how to fix?

CodePudding user response:

It is a bug on DataGrip side. I've filled a new ticket: DBE-16303.

Feel free to follow it.

CodePudding user response:

Are you sure you didn't skip the creation of the segment product_image_lob_seg?

  • Related