This discussion is archived
3 Replies Latest reply: Aug 24, 2012 10:32 AM by Reid Ricks RSS

Import Table

957792 Newbie
Currently Being Moderated
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
  • 1. Re: Import Table
    Khayyam Explorer
    Currently Being Moderated
    Statements for creation HR and OE users and all necessary data(tables and values)
  • 2. Re: Import Table
    Reid Ricks Explorer
    Currently Being Moderated
    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.
  • 3. Re: Import Table
    Biju Das Journeyer
    Currently Being Moderated
    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
    (path: ..\product\11.2.0\dbhome_1\demo\schema\human_resources)

    See: (Guidelines for Installing Sample Schemas)


    Edited by: biju2012 on Aug 24, 2012 10:54 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points