Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

securefile question

Murray SobolApr 18 2019 — edited Apr 18 2019

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

Comments
Post Details
Added on Apr 18 2019
5 comments
197 views