Thanks for the info but there's still some confusion. I am basically trying
to edit the export file to only have the grant statement in it. I then want
to run this
grant statement through back through the imp utility. I am doing this
because I need a way to grant/revoke
privileges to/from users without temporarily changing their passwords and
logging in as them. I
know that the import utility can do this with only having the become user
role
etc. The uglyDDL command simply pulls DDL out of the export file and you
must then run it by
hand, not through the import utility. Does this make more sense?
Sybrand Bakker wrote in message
<923864067.18763.0.rover.d4ee154e_at_news.demon.nl>...
>Hi Brian,
>
>From your description I understand you need to edit the DDL. Why not have
>imp creating a file with all DDL commands. The easiest way to do this is
>running imp with the following command line
>
>imp <username/pwd> file=/expdat.dmp full=y show=y log=<any file name>
>This file will contain all DDL commands, and only needs minor editing.
>Alternatively, you could consider using the utility by Steve Hauser,
>uglyDDL, which he has advertised several times in this newsgroup.
>It appears, also from this newsgroup, the first few characters of the
export
>file contain info about the character set the file is written in. I can
>understand imp starts complaining as soon as it doesn't find this info in
>the file.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
Received on Sun Apr 11 1999 - 18:33:37 CDT
