RE: Increase tablespace, which way is better?

[David Wagoner]

Title: Message

My first question is: Why are you adding a data file named "users" to your SYSTEM tablespace?  Do you mean to add this to your USERS tablespace?   Next, if you have an idea about the data growth or size of objects that you will place in the new datafile then you can better plan the initial size.  It's better to create it with an initial size close to your target value so that it doesn't have to dynamically extend.  At least that's what I would do with a data file that small (100 MB).  For small DBs, I usually set my data file max size to 2 GB.  Anything over that will mean adding another data file.     David B. Wagoner Oracle DBA