Hi Ann, (below is a quick and dirty method but proven very helpful occasionally) assuming you are talking about an 8i or 9i export file created with exp full=y you can use strings and grep utilities (of which there exist windows versions!) to extract the USER related sql statements. eg strings expdat.dmp|grep -i "create user"> creusers.sql strings expdat.dmp|grep -i "alter user" >> creusers.sql Then you can modify the creeusers.sql script as you like and run it. importing with SHOW=Y might also help to find the statements that exp stuffed in the export file for recreating the users. Hth, Andre 2007/7/11, Anant <shastry17@xxxxxxxxx>:
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