Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp 00038 when modifying exp file and running imp
The export file is NOT an ASCII file as you stated by your listing. It contains
binary data, e. g. ^@ which is a transliteration for hex 00, the NUL character
which is not written back to the file by vi as it means "no character at all" in
ASCII.
You can write a "substitute" program which will open the file as a binary file
and substitute strings by another string. But be careful when changing the
length of strings.
Of course, this is not supported either.
Martin
Viewer schrieb:
>
> 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 Mon Apr 12 1999 - 01:14:36 CDT