-
drop user
what is the easiest way to drop database user with many tables worth 40 GB tables and 50 GB indexes .
Thanks .
-
SQL> Drop user slimdave cascade;
I remember when this place was cool.
-
Originally posted by Mr.Hanky
SQL> Drop user slimdave cascade;
-
this is taking lot fo time may be several hours ..
also it gave message cannot allocate memory in sharedpool ...
can i do nologging ... something like that .
-
LMT or DMT? If DMT - you better phase it out. Drop individual objects separately during offhours. Eventually drop user. Else your smon will go crazy like you're probably seeing anyway. If LMT, the drop shouldn't take long anyway.
-
Truncate all the tables and drop the user.
OCP 7.3,8.0,8i,9i
-
It is LMT but still doing since last 2 hours , ofcourse i could see freespace from dba_freespace releasing slowly ...
but this is a time taking ...
-
From metalink -
"You'll only see 'issues' with dropping/truncate etc on massive extent numbers (in an LMT) if you are using tablespace quotas (because the quotas are still managed via a standard dictionary table).
In 9.2 the quota management is still there but a little smarter - if you drop 1,000 extents, there is only a single update to the tsq$ table not 1000"
-
Drop objects owned by this user throuhg multiple SQL*Plus sessions that run in parallel and then drop the user.
Oracle has to do the work of cleaning up objects worth @ 100GB. If you do it in parallel, it will feel faster.
svk
-
Thanks all ,
i did same thing ... Now i am done.
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
|