RE: [Q] does 10gr2 support rename schema?

From: Ken Naim <kennaim_at_gmail.com>
Date: Wed, 4 Apr 2007 09:49:26 -0400
Message-ID: <004801c776c0$0f7b84a0$6502a8c0@kenlaptop>

You cannot rename schemas, 10g added the capability to rename tablespaces.

Ken Naim

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Wednesday, April 04, 2007 8:44 AM
To: oracle-l_at_freelists.org
Subject: [Q] does 10gr2 support rename schema?

I need rename user account from "user1" to "user2" on ORACLE 10gr2. I know I can use "export/import" to do it, but does 10gr2 support rename schema or not?

Thanks  

---

---

Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.search.yahoo.com/toolbar/features/mail/
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 04 2007 - 08:49:26 CDT