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