Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


should an oracle database have more than one tablespace for data storage


should an oracle database have more than one tablespace for data storage  using -'oracle,oracle10g,tablespace'

My team maintains an Oracle database that is approx. 200GB in size. All of the data (tables, indexes, etc) lives inside a single 'USERS' tablespace. Is this a bad idea? What benefits are there to having multiple tablespaces, and under what circumstances would I want to add more to my database?

Thanks!
    

asked Sep 24, 2015 by tejas lakhani
0 votes
2 views



Related Hot Questions



Government Jobs Opening


...