|
-
bore..,
by using dba_data_files & dba_extents we can find how much one can resize the datafile(by giving block size).
So for resizing i joined these two tables and found the size(that can be resized).
dba_free_space gives you overall Freespace in that tablespace.
but from that one cannot resize the datafile because it may contain data.
Bore you know better than me.
if u need i will post that query how to find space in datafile that can be resized.without finding that how much can be resized in each datafile.If any tries to resize it shows error stating that
file contains used data beyond requested resize value..
Last edited by ams-jamali; 05-30-2007 at 05:57 AM.
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
|
Reply With Quote