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)
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
);
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
?