Kums wrote:
I have a 4K page size table space, and it has just multiple tables. (I
need to know as well if it's a single table in that tablespace, how
to handle.)
It has reached the maximum size of 64 GB and is full.
What options do I have to increase the table size?
Please give response for SMS and DMS.
The 64 Gb limit applies to a single table (i.e. you can have a 4k SMS
tablespace that's got 2 64 Gb tables in it) as well as DMS tablespaces
(i.e. you can't create a 4k DMS tablespace > 64 Gb).
Your options are to move to a tablespace with a larger page size, or
consider using the database partitioning feature (DPF), which makes
the limit 64 Gb per database partition.