Re: Import a user account from export file?

hello alan,

yes you can. and you don't need to know the deleted user's password or privileges to do that. just follow these steps:

re-create the user.
assign the new user default and temp tablespaces. grant connect to newUser.
grant resource to newUser.
imp sys/pwd_at_db file=exportedfile.dmp fromuser=deltedUser touser=newUser

and voila, you've created all the exported objects of deletedUser to newUser, the default tablespace of newUser would be used to create all these objects if any of exported tables didn't had any long or blob column in it. for tables that had blob column you might need to read oracle manual for further details!

hope that helps.

:) ATTA In article <8jlbaf$c9d$1_at_nnrp1.deja.com>,   alan_psb_at_yahoo.com wrote:
>
>
> I have an export file (full) from the user system, instance A.
>
> I drop a user in instance A accidentally. I want to create this
 user
> again. However, I do not know what privileges granted to him and his
> password. Can I use the export file to import the deleted user
 acccount
> into instance A (assume the user does not create any object)? If yes,
> how?
>
> Thanks,
> Alan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.