This content has been marked as final. Show 2 replies
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?
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