My Oracle Support Banner

Query Regarding Tablespace Configuartion (Doc ID 2452344.1)

Last updated on JUNE 25, 2019

Applies to:

Oracle FLEXCUBE Universal Banking - Version and later
Information in this document applies to any platform.


As per best practice document, there are multiple tablespaces in which the tables are to be divided in the database.

Now, some tablespaces are getting full rapidly whereas some have lot of space and very few tables.

Bank is concerned if this design is correct as there is lot of unused space.
Attached is the current configuration and usage in production

1. Is is better to use only 1 tablespace instead of so many?
2. How can LOB data be handled if multiple tablespaces are used?





In this Document
