| Shrinking - need room on computer [message #56785] |
Thu, 24 April 2003 10:51  |
Les Block
Messages: 1
Registered: April 2003
|
Junior Member |
|
|
I created a new user on a new oracle install. Used the USERS tablespace. Then did an IMP, but then decided to drop everything, but now computer is still nearly empty with hard drive space... How do i shrink the USERS tablespace, or the datafiles? How do you reclaim HD space with oracle?
Thank you very much.
Les
|
|
|
|
| Re: Shrinking - need room on computer [message #56786 is a reply to message #56785] |
Thu, 24 April 2003 11:05  |
Andy Hofer
Messages: 6
Registered: December 2002
|
Junior Member |
|
|
You can try this:
alter database datafile 'your_path/your_datafile'
resize x (k | m);
It may not let you shrink as much as you like. If not, you can export the objects in the USERS tablepspace, drop them, drop the USERS tablespace, delete the datafiles for the USERS tablespace, then re-create it and import your objects.
HTH,
Andy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
