2 Responses

Hi sir, I am Santhosha working as a junior dba. I have created a sql script by using above sript, In that i need to add tablespace and quota size dynamically. for example i have three tablespace ‘abc,’def’,ghi’ for each tablespace i need to specify different quotas means for tablespace ‘abc’ i need to specify 1m quota, and def unlimited so on.Like this users can specify different quota size as per requirements. below is my script, i have used utl_file which contains tablespace names. but i am not able specify quota size dynamically any help would be appreciated. Below is my script.