Home » RDBMS Server » Server Utilities » How to copy .dmp files of other database to our database
How to copy .dmp files of other database to our database [message #289594] Mon, 24 December 2007 03:49 Go to next message
balajiags
Messages: 10
Registered: July 2007
Junior Member
hello all group members

i have a .dmp file as HOFAS which is created from a database
whose User Name is hofas & Host String is nrclinux.

i want to copy all tables with data in my database for testing
.My database user Name is scott & hostring is axiom

What shoud i do? please give me step by step solution.As I dont know about DBA concepts.
Re: How to copy .dmp files of other database to our database [message #289597 is a reply to message #289594] Mon, 24 December 2007 04:06 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
import it easily.

on command prompt write imp and enter
then follow the instructions.

regards,
kaushal
Re: How to copy .dmp files of other database to our database [message #289601 is a reply to message #289597] Mon, 24 December 2007 04:25 Go to previous messageGo to next message
balajiags
Messages: 10
Registered: July 2007
Junior Member
which instructions
Re: How to copy .dmp files of other database to our database [message #289605 is a reply to message #289601] Mon, 24 December 2007 04:49 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those that appears when you type "imp".
Or try "imp help=yes" and choose the options.
You can also read the documentation: Database Utilities

Regards
Michel
Previous Topic: Migration From Pervasive database into Oracle
Next Topic: character set mismatching in import
Goto Forum:
  


Current Time: Sat Dec 03 16:25:47 CST 2016

Total time taken to generate the page: 0.10311 seconds