-
Best method for resizing a tablespace
I'll like to know from any Oracle DBA guru the best way to resize a tablespace. I see DBA's usually edit and change the old size say from 40MB to 75M or is it better to add a new datafile or through SQLPlus to execute command like:
ALTER DATABASE DATAFILE '/oracle/test.dbf' RESIZE 75MB;
This is for both temporary local or permanent dictionary managed tablespace. Your advice will be highly appreciated.
C. K.
Apps DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|