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