Re: Importing database issue

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_at_gmail.com>:
>
> 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