I m novice about Database. I installed Oracle 10g express edition. After creating HR user I drop the user. But the in-built tables like employees, departments etc are required to me. So how to retrieve that tables in another user account.. Plz help
If you need those tables in another user account, once they are recreated you can do create table as select from the user account where you want them to reside or you could try datapump export and datapump import with the remap_schema parameter to import them under a new user.