Use the EXP utility to export this users schema objects and data.
Create a new account with a the name you want. Use the IMP utility
to import the objects and data of the original user to the new user.
You will need to use the "fromuser" and "touser" clause.
> Hi to all,
> I need to change the user/schema name of a schema whose name contains
> 'forbidden' character: '\'.
> I tried by using Alter user command, but i did not get the
> change the user name.
> Is it possible?
> Which command can i use for this?
> Note: I'm logged as system.
> Any help would be very appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.