Query Regarding Tablespace Configuartion
(Doc ID 2452344.1)
Last updated on OCTOBER 01, 2018
Applies to:Oracle FLEXCUBE Universal Banking - Version 126.96.36.199.0 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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document