Code:
Set Head off
Set Feedback off
Set Trimspool on
Spool C:\Apps\Base\Count_In_Table.sql
Select
'Select Count(*) from '||Table_Name||';'
From
DBA_TABLES
Where
Owner = 'SCHEMA_NAME'
;
Spool off
Set Head on
Set Feedback on
Spool C:\Apps\Logs\Count_In_Table.log
@C:\Apps\Base\Count_In_Table.sql
Spool off
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote