TableSpaces, DataFiles and Extents to BLOB management
We need to create a database, which will contain two schemas, one of them requires only 4 tables, the other 27, all the tables will use blob fields; Except for one blob field between all the other objects, approximately 5 GB of space is required per year. However, the last blog field will require approximately 850GB of annual storage space. We are planning to create a transactional database with 5 tablespaces: 1 for the basic data (NUMBER, VARCHAR, etc.) 1 for the indices of the basic data 1 for the blobs of the 31 tables. 1 for the indexes of the blobs and 1 for the
0