Re: exp - imp problem

Suzy is right -- indexfile ONLY shows table and index ddl.... show =y (works on all versions that I have used 7.3 and up) although it's hard to read.

strings works really really well on Unix :)

>From: "Suzy Vordos" <lvordos_at_uswest.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: exp - imp problem
>Date: Thu, 13 Jul 2000 04:55:17 -0800
>
>
>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).
>--
>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).