Linux Server Administration
Friday, April 15, 2011
How to reduce size of tablespace
If temp is the tablespace that need to be reduced
1. Create new temp1 tablespace
2. Make new temp1 tablespace as default
3. Drop the temp tablespace
4. create temp tablespace
5. Make the temp tablepsace as default
6. Drop temp1 tablespace..
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment