Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OWAREPL Upload.exe utility
Tom,
Thanks for the reply and sorry for the typo and confusion. I am trying to unload images from the db to the filesystem. I have tried it as you suggested and it keeps erroring out as if I am not supplying the proper number of args. Also, would the fact that I compiled it using Oci80 affect it in any way.
Thanks again for you assitance,
Tom
In article <35c10251.10445469_at_192.86.155.100>,
tkyte_at_us.oracle.com wrote:
> A copy of this was sent to tcreedon_at_my-dejanews.com
> (if that email address didn't require changing)
> On Tue, 28 Jul 1998 16:41:07 GMT, you wrote:
>
> >I have compilied the upload.exe utility from the Oracle web replacement
> >cartridge package. When I attempt to run it from the command line it
> >produces a n error msg "useage: unload user/pass_at_db 'select LONG_RAW,
> >FILE_NAME ....' "
> >
> >I have tried a number of SQL statements to get it running but so far I am
> >missing the pattern. If I just run upload joe/shmoe_at_mydb '' with out any sql
> >or filename I can connect to the DB, but then as expected, it errors out due
> >to a lack of arguments. Can some one point me in the right direction here, I
> >am using the Image table that can with Tom Kytes package and Oracle 8
> >Enterprise on an NT4.0 box, and MSVC++5.0.
> >
> >Thanks in Advance,
> >
> >Tom
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
> Well, its not 'upload' its really UNLOAD. Unload is used to dump the contents
> of a long raw column to a file. the way it works is:
>
> C:\> unload scott/tiger 'select image, name from image'
>
> That would take each row in the IMAGE table, select out the column IMAGE and
> NAME -- It would create (for each row) a file called NAME (whatever is in the
> name column) in the current working directory. It will put the contents of
the
> LONG RAW into that file.
>
> In short, its a general purpose long raw unloader. If you have a table with a
> long raw and you want to unload it, you can use this.
>
> In addition to unload, there is a load utility in owarepl as well. It is
found
> in owarepl/src/load. It is a command line loader of long raws. It has the
> syntax:
>
> useage: ./load user/pass_at_db filename mime_type <tname>
>
> It only knows how to load into the 'image' table that owarepl uses (whereas
> unload can unload from ANY table, load can only load into a table that has at
> least 4 columns name varchar2(255), img_size number, mime_type varchar2(30),
> image long raw)...
>
> You can use this to load any OS file into the image table without going
through
> the web to upload it...
>
> So... I have the question now ... are you trying to load or unload the image
> table? Its not really clear from your posting what you are trying to do with
> this...
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Herndon VA
>
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 28 1998 - 15:22:48 CDT