I am trying to create a new Oracle 18c database using securefiles for LOB storage.
My "create tablespace" looks like this:
CREATE TABLESPACE "SMARTSOFT_DATA"
DATAFILE 'F:\Database\Oracle18\DVLP18C\Data Files\SMARTsoft_Data.dbf'
SIZE 200M
REUSE
AUTOEXTEND ON
MAXSIZE 4096M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 64K
SEGMENT SPACE MANAGEMENT AUTO
;
I created this:
CREATE USER grainv2019unicode
IDENTIFIED BY sql
DEFAULT TABLESPACE SMARTSOFT_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON SMARTSOFT_DATA
QUOTA UNLIMITED ON SMARTSOFT_INDEX
;
GRANT CONNECT,
RESOURCE,
CREATE VIEW,
ALTER ANY TRIGGER,
CREATE PUBLIC SYNONYM TO grainv2019unicode
;
and added this:
ALTER SYSTEM SET db_securefile=PERMITTED SCOPE=both;
When I create a table containing a LOB I get this error:
Error report -
ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
60019. 00000 - "Creating initial extent of size %s in tablespace of extent size %s"
*Document: YES
*Cause: Creation of SECUREFILE segment failed due to small tablespace
extent size.
*Action: Create tablespace with larger extent size and reissue command.
I ran this command form SQL*Plus:
select tablespace_name, initial_extent, next_extent from dba_tablespace where tablespaced_name = 'SMARTSOFT_DATA: and got this output:
TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT
------------------------------ -------------- -----------
SMARTSOFT_DATA 65536 65536
What am I missing - something obvious I hope
FYI: I have other schemas created in this tablespace not using LOBs; part of the project is to convert LONGs to LOBs.
Thanks
Murray