Re: OEM Problem?

From: Gaja Krishna Vaidyanatha <oraperfman_at_yahoo.com>
Date: Tue, 14 Oct 2003 09:14:25 -0800
Message-ID: <F001.005D3131.20031014091425@fatcity.com>

Ryan,

If your goal is to drop the user, then the following should work:

SQL> drop user "OEM_RYAN-2LE36OFJCE_OEMREP" cascade;

Alternatively, if you still want to connect to this user, the following should work too:

SQL> connect "OEM_RYAN-2LE36OFJCE_OEMREP"

Then when prompted for the password, type it in. Bottom line is that you need to use "double quotes" around the username, needs to be in upper case.

Hope that helps,

Gaja
--- Ryan <rgaffuri_at_cox.net> wrote:
> for some reason when i created the OEM repositiory
> the OEM assistant created the following username.
>
> OEM_RYAN-2LE36OFJCE_OEMREP
>
> I cant connect to this user, drop it or alter it
> because of '-' in the name. how do i get rid of the
> repository and start over?
>
>
>

---

Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation E-mail : gaja_at_veritas.com Phone: (650)-527-3180 Website: http://www.veritas.com

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: oraperfman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 14 2003 - 12:14:25 CDT