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