tag:blogger.com,1999:blog-940885937847335876.post7677414568410468395..comments2024-01-31T15:08:14.203+05:30Comments on One Can Succeed at Almost Anything For Which He Has Enthusiasm...: Drop all object of SchemasNEERAJ VISHENhttp://www.blogger.com/profile/04032578930084182369noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-940885937847335876.post-74209290755216372132014-08-31T23:42:40.639+05:302014-08-31T23:42:40.639+05:30Hi Neeraj,
I am trying to drop all the schema obje...Hi Neeraj,<br />I am trying to drop all the schema objecs at once,but it is taking long time to drop all the schema objects and the schema size 178GB.<br /><br />OWNER OBJECT_TYPE VALID INVALID<br />------------------------------ ------------------- ---------- ----------<br />test1 FUNCTION 30 0<br />test1 INDEX 1210 0<br />test1 LOB 21 0<br />test1 MATERIALIZED VIEW 21 25<br />test1 PACKAGE 48 0<br />test1 PACKAGE BODY 37 11<br />test1 PROCEDURE 2 1<br />test1 SYNONYM 7 0<br />test1 TABLE 409 0<br />test1 TRIGGER 389 4<br />test1 VIEW 377 2<br />I am using the below command to clean up the schema<br />exec sys.dbutils.drop_schema(ps_schema=>'TEST1');<br /><br />Let me know is there any way to calculate the time required to cleanup the schema?<br />Regards,<br />ahmedAnonymoushttps://www.blogger.com/profile/10641933186000255341noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-29594398796520714212014-03-04T02:10:19.217+05:302014-03-04T02:10:19.217+05:30I like the helpful info you provide in your articl...I like the helpful info you provide in your articles.<br />I'll bookmark your weblog and check again here frequently.<br />I am quite certain I will learn plenty of new stuff right here!<br />Best of luck for the next!<br /><br />my web-site - <a href="http://www.siteinwwweb.org" rel="nofollow">spekulant</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-17076080188142562192012-07-03T11:44:09.297+05:302012-07-03T11:44:09.297+05:30Hi Chandu
Checj your mail.Hi Chandu <br /><br />Checj your mail.NEERAJ VISHENhttps://www.blogger.com/profile/04032578930084182369noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-42799456406574162882012-07-03T02:40:33.815+05:302012-07-03T02:40:33.815+05:30Hi neeraj, is their any script to delete all schem...Hi neeraj, is their any script to delete all schemas ina db except default schema's?<br /><br />send me the script to chandureddy208@gmail.com<br /><br />thanks in advanceOracle DBAhttps://www.blogger.com/profile/13853786528521753164noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-32117466037395435632012-01-11T04:15:07.353+05:302012-01-11T04:15:07.353+05:30@anonymous :
if we do srop user cascade it deletes...@anonymous :<br />if we do srop user cascade it deletes entire schema along with the objects but sometimes we need to delete only objects but not schema then in this situations we go for a script.<br />follow the link for the script : <br /><br />http://chandu208.blogspot.com/2011/09/scripts.htmlOracle DBAhttps://www.blogger.com/profile/13853786528521753164noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-72597775582490526382011-09-23T11:17:52.278+05:302011-09-23T11:17:52.278+05:30This is because if you don't have the privlege...This is because if you don't have the privlege of "drop user" then how you will remove the object of schemas??<br /><br />I have already mention when to use this method. :)<br /><br />--neerajNEERAJ VISHENhttps://www.blogger.com/profile/04032578930084182369noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-8644572077026655342011-09-22T18:26:09.416+05:302011-09-22T18:26:09.416+05:30Why not use
drop user cascade
?
Why this cumber...Why not use <br />drop user cascade<br />?<br /><br />Why this cumbersome method?Anonymousnoreply@blogger.com