Frequently Asked Questions on Tablespaces

Is it mandatory to create tables or index with the tablespace?

Whenever an object is created without mentioning the tablespace name, it gets stored in the default tablespace which causes it to get full early. Thus, it is good practice to add a tablespace name while creating an Oracle object.

Do we really need to care about Tablespace, can’t we add more storage when the primary one is full?

Definitely, DBAs can extend the datafiles or add another tablespace. However, storage comes with a price. More the storage, the higher the price.

A database, as defined by Oracle, is an organized collection of information typically stored electronically in a computer system. The explanation is simple, however, it’s not that simple to store the data.

The Database has a tablespace that stores all the data. Everything inside a database is stored in tablespace.