-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|