Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unix strings command on exp file (was Re: Editing an Export (.dmp) file)
Joel Garry wrote:
> In article <01bd0bd5$a0271f60$1102015a_at_softdump>,
> Gerard H. Pille <ghp_at_skynet.be> wrote:
> >Don't you get a readable file when you export without data?
>
> It depends what you mean by "readable." It is mostly readable, but has
> some non-SQL characters in it. It would be really handy to get rid
> of those characters. It would be especially handy to do it automagically.
> Even a sed script. There are few enough that one can do it in vi, but that
> is a manual operation. Strings command works just right except for that
> line length limitation.
>
> The stuff in that file is much more concise and accurate than any collection
> of DBA scripts that I have seen when walking into a strange database.
>
> Of course, over the years I have seen some pretty god-awful screwups by
> exp/imp, so I don't think it is the be-all and end-all. But something like
>
> exp myuser/mypasswd ROWS=N FILE=table_defs.dmp
> strings table_defs.dmp > table_defs.lst
>
> has been so handy, I wish it would always work.
>
>
Actually, do the export as described, and then do an import using the 'indexfile' parameter. All but the 'CREATE INDEX' commands will need to be un'remmed, t\but that is a trivial task with sed.
Bill Received on Thu Dec 25 1997 - 00:00:00 CST