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.
All scripts necessary to install sample schemas reside in $ORACLE_HOME/demo/schema directory.
eg, Filename: hr_code.sql is the script you will find in the human_resources directory
See: http://docs.oracle.com/cd/B28359_01/server.111/b28328/installation.htm (Guidelines for Installing Sample Schemas)
Edited by: biju2012 on Aug 24, 2012 10:54 AM