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@xxxxxxxxx] 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l