| Best way to extend tablespace [message #62517] |
Mon, 26 July 2004 06:12  |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hi,
last time a tablespace (with no aotoextend on) on a 8i-db became full. We resized the datafile. But now I wonder, what is the best way to extend a tablespace on a running db?
- Resize the datafile?
- add a datafile to the tablespace?
- in case of no autoextend on- simply activate the autoextend?
Are all three posssibilties possible in a running system? And which one is the best?
|
|
|
|
| Re: Best way to extend tablespace [message #62520 is a reply to message #62517] |
Mon, 26 July 2004 06:48  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
I don't think it matters much either way. Personally I would try to extend the files (AUTO or manually) so you end-up with fewer files to manage. However, if the disk is too busy, rather add another file on a separate disk.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
