Hi guys,
I wanted to make a tablespace read-only after 3 days of its creation and drop it altogether along with the datafiles in it after 45 days. The tablespace holds only one table called State.
I can get the information connecting as system/manager using the follwing script.

select a.table_name,a.tablespace_name,b.created
from all_all_tables a,all_objects b
where a.table_name=b.object_name
and a.table_name='STATE';

I guess it requires a script to be written in shell script. Can someone help me? And is there anyway without writing a shell script but making it automated?(i am new for scripting).

I want also to automate the script to run everyday at a particular time.
Thanks in advance
manjunath