|
-
Recover disk space from tablespaces
I ran the following:
select sum(bytes)/1024/1024/1024,tablespace_name from dba_free_space
where tablespace_name IN ('UNDOTBS1', 'USERS') group by tablespace_name;
SUM(BYTES)/1024/1024/1024 TABLESPACE_NAME
------------------------- ------------------------------
0.5606689453125 UNDOTBS1
3.44195556640625 USERS
How do I actually recover the indicated free space?
Thanks in advance.
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
|