delete mass records
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
select 'drop user' || username || 'cascade;' from dba_users where account_status=locked;
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
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
Click Here to Expand Forum to Full Width