| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: OWAREPL Upload.exe utility
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
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. Received on Tue Jul 28 1998 - 11:59:47 CDT
 |
 |