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