Hi Anant

You need to do a bit more study to get this one right try the ignore
parameter and the fromuser and touser parameter to import indiviudal
user objects in a schema, I would highly recommend a log parameter

See the
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
for this

Cheers

Peter

-----Original Message-----
From: Anant [mailto:shastry17@(protected)]
Sent: Wednesday, 11 July 2007 02:34 PM
To: oracle-l
Subject: Importing database issue

Hi gurus,

I have an export dump of my database. Accidentally i dropped all the
users with cascade option. Now how can i import only the user info from
my export backup. Doing full import database( full=y) is throwing errors
having users doesnot exists .Does anyone have idea. Please suggest me.

Thanks,
Ann
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l