How do we increase the storage capacity of E-notebook Database?

How do we increase the storage capacity of E-notebook Database?

You can do the following to add more free space to a tablespace (T_ENDB_ST1_LOB tablespace as an example):

-- First, check the current state from the datafiles in the tablespace
-- Check if they are not autoextensible and  if they cannot longer grow beyond the max size
-- the biggest max size is 32GB for tablespaces using 8k blocksizes

select file_name, autoextensible , round(bytes/1048576/1024,2) SIZE_GB ,  round(maxbytes/1048576/1024,2) MAXSIZE_GB
from dba_data_files
where tablespace_name='T_ENDB_ST1_LOB';

-- If they are not autoextensible and they have not grow until the maxsize
-- you can change the autoextend clause and increase the max size until 32GB.

alter database datafile 'C:\APP\ADMIN\ORADATA\ORADB\T_ENDB_ST1_LOB.DBF' autoextend on next 100M maxsize 32G;

-- If they are are not supposed to be autoextensible, but they still can grow up to the maxsize,
-- you can resize the files running:

alter database datafile 'C:\APP\ADMIN\ORADATA\ORADB\T_ENDB_ST1_LOB.dbf' resize 3072M;

-- If you cannot modify the previous files,
-- then add a new datafile to the tablespace using the following statements:

alter tablespace T_ENDB_ST1_LOB
add datafile 'C:\APP\ADMIN\ORADATA\ORADB\T_ENDB_ST1_LOB_02.DBF' size 100M autoextend on next 100M;

-- Get the datafiles path from the first query