Import dmp file.

Hi

i have a existing db (stock) with more than one schemas running on the server, and i got a another copy of a schema as dump file. i want to import the dump file inot that particluar db. ( I don't want any existing data from the current db)

I did the follwing:

Shoutdown the db
Took a backup of existing db
Removed all the data files except the shell

Copy the client's database .DMP file to an appropriate directory (d:\oradba\admin\stock\imp\)
Create a parfile to import the full database – call it stock.par:

USERID=SYSTEM/MANAGER
LOG=d:\oradba\admin\stock\imp\stock.LOG
FILE=d:\oradba\admin\stock\imp\stock.DMP
FULL=N
FROMUSER=localstock
TOUSER=localstock
localstock is the schema name

In dos window:
SET ORACLE_SID=stock
IMP PARFILE=D:\ORADBA\ADMIN\stock\IMP\stock.PAR

but import failed:

My question is:
to import do i need to create a new databse? or how can i import to the existing db by removing all the existing data?

Please if someone knows help me. Little bit urgent

Thanks
Kiru

why did it fail

My question is:
to import do i need to create a new databse? or how can i import to the existing db by removing all the existing data?

The way to import by dropping is to drop user xxxx cascade that will drop all the objects of the user .then recreate the user again grant connect ,resource to the user then do an import.

hope this helps

or dont do the grant connect, resource privs to anyone as they are way too powerful

Quote:

---

Originally Posted by kiru

...
I did the follwing:

Shoutdown the db
Took a backup of existing db
Removed all the data files except the shell

---

Yes, If you removed all the data files, you do need to create a database to be able to import! :rolleyes:

Thanks Done it

Good luck! :D