Home » RDBMS Server » Server Utilities » How to Create the database from the DMP file
How to Create the database from the DMP file [message #72795] Wed, 22 October 2003 05:44 Go to next message
Prashnat Sangoi
Messages: 1
Registered: October 2003
Junior Member
Hi,

I have a database dmp file having all the data for a database schema now I want to Import that file to create a database schema . Tell me step wise what to do.

Report message to a moderator

Re: How to Create the database from the DMP file [message #72801 is a reply to message #72795] Wed, 22 October 2003 10:33 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
If you have the database already, just create a user with CONNECT,RESOURCE privileges and assign default,temporary tablespaces with sufficient space and import the dumpfile into this schema using
imp user/pass file=dump.dmp fromuser=source_user touser=dest_user commit=y destroy=n feedback=10000 buffer=10240 log=imp_dump.log ...

see UTILITIES manual for more details..

-Thiru

Report message to a moderator

Previous Topic: How to Generate table Creation Scripts of a specific user as it is in ORACLE 8
Next Topic: SQL*Loader-282: Unable to locate character set handle for
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 20:58:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.