Hi,
Using oracle 11.2.0.3 and want to determine that some new tablespaces will be large enough to accomodate the data we plan to move into them these will be large enough.
When look in oracle enterprise manager see the tablespaces but all look to have a default 1024 mb and when run query below don't even see the tablespaces.
Other team created these and advised 4gb but want to double-check this.
How can we be sure 4gb been allocated to each of the tablespaces concerned before we move the data.
select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
where tablespace_name like '%RTRN%'
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
order by 1
Thanks