Unconfirmed !

=========================================
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for Solaris: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

SQL> drop user aks;

User dropped.

SQL> create user aks identified by shah;

User created.

SQL> grant connect,resource to aks;

Grant succeeded.

SQL> alter user aks rename to lazyaks;
alter user aks rename to lazyaks
*
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter user aks rename lazyaks;
alter user aks rename lazyaks
*
ERROR at line 1:
ORA-00922: missing or invalid option
===================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA

----- Original Message -----
From: "Oracle DBA "
<oracledba-ezmlmshield-x67645019.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, June 30, 2004 3:30 PM
Subject: -----> Schema/User Rename <------


>
> Hello All,
>
> I heard some where that the 'SCHEMA/USER' rename option is available with
10g ? Is that true ? Please confirm.
>
> Thanks All,
>
> Sam.
>
>
>

Oracle LazyDBA home page