delete mass records

hello,
Iam using SuseLinux server,oralce9.2 . i have nearly 35000 users in prodution database each users are linked with 170 tables.In that nearly 6500 users are disabled that is . the account is closed.I want to remova all disabled users from my db.All i have to do in 30 min pls help.

thanks in advance

spool drop1.sql
select 'drop user' || username || 'cascade;' from dba_users where account_status=locked;
spool off

@drop1.sql

this scrip would collect the list of disabled users & drop them one by one
try it on first on ur test database make sure there r no depending objects
corresponding to the users being dropped with current users

thanks giriraj,
The problem is ,when a user singup his account willbe added in the person (master)table from master it is linked to other tables.So I want to remove his account from the table.

so this is an application thing, not a database thing - only you know the sql for doing that