Can one rename a database user (schema)? (for DBA)
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
60. Can one rename a database user (schema)? (for DBA)
No, this is listed as Enhancement Request 158508. Workaround:
Do a user-level export of user A
create new user B
Import system/manager fromuser=A touser=B
Drop user A
(Continued on next question...)
Other Interview Questions
|