This discussion is archived
2 Replies Latest reply: Jan 18, 2013 8:43 AM by kumar73 RSS

how to load a .dmp file into oracle table

kumar73 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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