This content has been marked as final. Show 3 replies
Statements for creation HR and OE users and all necessary data(tables and values)
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