2 Replies Latest reply: Jan 18, 2013 10:43 AM by kumar73 RSS

    how to load a .dmp file into oracle table

    kumar73
      Hello Friends,

      I have a .dmp file to be loaded into oralce table . My oracle DB is on WINDOWS . I am using sql developer [ version 3.0.04] as UI Client for DB.

      example : dataset_prop.dmp this dmp file is to be loaded into DATASET_PROP table.

      Pls advice.

      Thanks/kumar
        • 1. Re: how to load a .dmp file into oracle table
          SomeoneElse
          But what's a "dmp file"? Where did it come from? What's in it? What format is it in? How/who/what created it?
          • 2. Re: how to load a .dmp file into oracle table
            kumar73
            Issue resolved .


            DMP file is created by ORACLE DBA using exportdump utility for us to create DB tables . We have to use IMP utility to create db ojbects.

            The dmp file contains table structure and the reccords to be loaded into the table.

            command:

            c:\oracle\product\11.1.1\Oracle_ODI_2\bin> imp user/pwd@dbname file=<path to .dmp file> fromuser=<user> touser=<user> tables=<table_name>

            example:

            c:\oracle\product\11.1.1\Oracle_ODI_2\bin>imp abc/abcl@pub file=C:\Users\kumar\Desktop\DATASET_RESOURCE.dmp fromuser=abc touser=abc tables=DATASET_RESOURCE


            Thanks/Kumar

            Edited by: kumar73 on 18 Jan, 2013 8:42 AM