renaming a database user

[zulu99]

Hi all


I would like to know In oracle if its possible to rename a database user (schema)

If yes what is the syntax

If no , then how to acheive this

say if i have schema name testuser1 with its own set of tables & stored procs

& now testuser1 has to be renamed to testuser2


Rgrds

[Thomasps]

Can't rename directly

Do a user-level export of user testuser1
create new user testuser2
import system/manager fromuser=testuser1 touser=testuser2
drop user testuser1