Re: ....A drop schema script ??

2001-05-21 Thread Jared Still
On Friday 18 May 2001 18:01, Jacques Kilchoer wrote: I hope Mr. Still won't mind if I post another script in the same vein, that I used after hearing him recommend this approach. This one also drops public synonyms for objects in the schema being dropped. Please note that

RE: ....A drop schema script ??

2001-05-19 Thread Christopher Spence
DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script

Re: ....A drop schema script ??

2001-05-18 Thread Luis DeUrioste
DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script

RE: ....A drop schema script ??

2001-05-18 Thread Jacques Kilchoer
Title: RE: A drop schema script ?? -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] I've found that when dropping a schema owner, it's much easier to drop their objects individually, then drop the user. I hope Mr. Still won't mind if I post another script

....A drop schema script ??

2001-05-17 Thread Luis DeUrioste
All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1

Re: ....A drop schema script ??

2001-05-17 Thread Rocky Welch
How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax

RE: ....A drop schema script ??

2001-05-17 Thread John Lewis
Login in as system: drop user user_name cascade; -Original Message- Sent: Thursday, May 17, 2001 12:26 PM To: Multiple recipients of list ORACLE-L All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly

RE: ....A drop schema script ??

2001-05-17 Thread Diego Cutrone
] Sent: Thursday, May 17, 2001 4:48 PM How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I

Re: ....A drop schema script ??

2001-05-17 Thread Luis DeUrioste
uhhh DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would

Re: ....A drop schema script ??

2001-05-17 Thread Jared Still
thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A Content-Type: text/x-vcard