Re: unix strings command on exp file (was Re: Editing an Export (.dmp) file)

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.

>
>Joel Garry <joelga_at_pebble.ml.org> schreef in artikel
><66q2h2$ttk$1_at_pebble.ml.org>...
>> In article <01bd045e$c104dc00$2890f5ce_at_laptopmr>,
>> Matthew F. Reagan <mreagan_at_fast.net> wrote:
>> >Gee, I haven't given this much thought in quite a while. Kevin Loney
 and I
>> >did a presentation on this at IOUW back in 91(?). In that presentation,
 we
>> >discussed the structure of an export file, and how to edit it.
>> >
>>
>> In a related question, I would like to use the strings command to get a
 quick
>> and dirty command file with proper sizing of objects and so forth, but it
>> seems to truncate after 1024 characters. Does anyone know if there is
 some
>> environment setting for this (Solaris 2.5)? The man doesn't seem to
 address
>> this, and try doing a dejanews search on "strings" haha.
>> --
>> These opinions are my own and not necessarily those of Information Quest
>> jgarry@eiq.com http://www.informationquest.com
>> http://ourworld.compuserve.com/homepages/joel_garry
>> "See your DBA?" I AM the @#%*& DBA!
>>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!