Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center