This blog post provides a simple piece of PL/SQL which will delete every object owned by the currently logged in user.Here is the PL/SQL block;declare v_ItemCount integer;begin SELECT count(*) INTO v_ItemCount FROM ALL_OBJECTS AO WHERE AO.OWNER = USER AND AO.OBJECT_TYPE NOT IN ('INDEX') AND AO.OBJECT_NAME NOT LIKE 'BIN$%'; while (v_ItemCount > 0) loop for v_Cmd in (SELECT 'drop ' || AO.OBJECT_TYPE || ' ' || AO.OBJECT_NAME || ...
Friday, November 26, 2010
Thursday, November 25, 2010
Probably the most important thing I can do first is to describe the environment I'm using; we have a global Active Directory forest with local domain controllers in each country. We have Windows 2003 servers running IIS 6 in both test and production - Developers (like myself) have a normal user account and a "Domain Administrator" account for working with remote servers. We use Kerberos for authentication (which requires a slight change to the process, see later).The website itself has been generated using Visual Studio 2008. It has a single label...
A simple step-by-step guide for end users on how to open additional mailboxes (assuming you have been granted the appropirate permissions) using Outlook 2007 and Microsft Exchange Mailboxes in a Corporate Environment.Open Outlook 2007 as you would normallyAccess the “Tools” menu and select “Account Settings ...”Ensure that “Microsoft Exchange” is selected and click the button marked “Change...” just above and to the right of it.Click on “More Settings...
Subscribe to:
Posts (Atom)
