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

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Apr 2007 09:49:26 -0400

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

Ken Naim

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of dba1 mcc
Sent: Wednesday, April 04, 2007 8:44 AM
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l


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


Other related posts: