Organizational Research By

Surprising Reserch 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

5 Answers

0 votes
NULL
answered Sep 24, 2015 by vimaldas2005
0 votes
NULL
answered Sep 24, 2015 by mannumits1
0 votes
NULL
answered Sep 24, 2015 by suyesh.lokhande
0 votes
NULL
answered Sep 24, 2015 by badhwar.rohit
0 votes
NULL
answered Sep 24, 2015 by deepak

...