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

    how to load a .dmp file into oracle table

      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.

        • 1. Re: how to load a .dmp file into oracle table
          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
            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.


            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>


            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


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