Re: exp - imp problem

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Thu, 13 Jul 2000 00:56:09 -0600
Message-Id: <10557.111923@fatcity.com>

That should work, or for fun, you could examine what the export file has. If your platform is Unix, use strings/grep to search the export file. Here is an example where I searched for user PCAT:

$ strings expfile.dmp | grep GRANT | grep PCAT GRANT "CONNECT" TO "PCAT"
GRANT "RESOURCE" TO "PCAT" Then you'll know for certain!
Suzy

> Uma Sankara_Sivadanam wrote:
>
> Hi all,
> I am having a full export of an database and now i need to import only
> a perticular user's schema from that dump.I droped the user before
> import with out looking at the roles that are granted to that user.Now
> after recreatng that user i am clueless that what kind of roles that
> user got.
>
> Will my import fail if i just give connect and resource to that new
> user and perform import?
>
> Thanks,
Received on Thu Jul 13 2000 - 01:56:09 CDT