3 Replies Latest reply: Aug 24, 2012 12:55 PM by Biju Das RSS

    Import Table

    957792
      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
          Statements for creation HR and OE users and all necessary data(tables and values)

          http://uploading.com/files/get/543a3176/sample_schema_scripts.zip
          • 2. Re: Import Table
            Reid Ricks-Oracle
            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
              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: http://docs.oracle.com/cd/B28359_01/server.111/b28328/installation.htm (Guidelines for Installing Sample Schemas)

              Regards
              Biju

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