Re: exp - imp problem

Excellent point (was I tired, or just taking the easy way out?). However, indexfile generates create table/index ddl, while show=y generates all, at least on 8.0.x.

Suzy

Suhen Pather wrote:
>
> Hi
>
> You can also use show=y or indexfile option with the import utility to generate the ddl.
> The indexfile option works really well and you can use the output to grant your roles, create users, tables, indexes, all object creations
>
> Regards
> $uhen
> Oracle DBA
> Telkom SA
>
> >>> lvordos_at_uswest.com 07/13/00 11:23AM >>>
>
> 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,
> > Uma Shankar
> --
> Author: Suzy Vordos
> INET: lvordos_at_uswest.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Suhen Pather
> INET: pathers5_at_telkom.co.za
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jul 13 2000 - 06:35:51 CDT