السلام عليكم

معلومه مفيده احببت مشاركتها معكم

********************************************************************************
************

To Know the real size of tables per Mega

select table_name,(num_rows*avg_row_len)/(1024*1024) MB
from user_tables
where table_name='T1

********************************************************************************
*************

To Know the schema size per miga

select owner,sum(bytes)/1024/1024 from dba_segments
where owner = 'Schema_name'
group by owner

********************************************************************************
*************
To Know which user own DBA role

SELECT grantee
FROM dba_role_privs
WHERE granted_role = 'DBA'
ORDER BY grantee;

السلام عليكم
بصراحة معلومات حلوة
ياريت يكون في تاني زي كده
شكرا لك وبارك الله فيك

script to move all tables from tablespace to another one on one shot

select 'ALTER TABLE ' || table_name || ' MOVE TABLESPACE NEW_TPS_NAME ;'
from dba_all_tables
where owner='Schema_owner'
and tablespace_name='OLD_TPS_NAME'

********************************************************************************
***

script to move indexes from tablespace to another one on one shot

select 'ALTER INDEX '|| INDEX_NAME ||' REBUILD TABLESPACE NEW_TPS_NAME;'
from DBA_INDEXES
where tablespace_name='OLD_TPS_NAME'
and TABLE_OWNER='Schema_owner'
order by table_name;