msimons4
asked on
Datafile
I have move all tables from one tablespace to a newly created tablespace. I have also move and rebuilt all indexes from this tablespace to the new tablespace. When I query the anount of space each object is taking up there is a total of 800M. But the tablespace is taking up 17000M. What is responsible for taking up this extra space?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If rows were deleted how do you get the space back after moving it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Space used by objects:
SELECT distinct owner, segment_name, segment_type, a.bytes/1048576
FROM dba_extents a, dba_data_files b
WHERE a.file_id = b.file_id
AND b.file_name = '/u02/oradata/CORELITE/dat
order by 3;