Re: file random write access from within a database

you have a file that you will upload with utl file and then latter at any point of time, you want to change few contents of the uploaded file. is it so..I do not think its possible..cause this uploaded file becomes a data element of certain object and associated datafile.

Quote
But this is rather unacceptable solution - I would rather imagine I open a file, set a position, write few bytes at this position (adding or eventually replacing some bytes on specified length), close a file. UnQuote

This is what something similar happen in Automated storage managed tablesapces but oracle archicture takes care of it..

thanks..subodh
2011/3/11 Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>

> hi,
>
> I wonder if it is possible to write to a file from within a database at
> the chosen position.
>
> What I want to achieve is to modify a kind of header of simple text file
> (few tens of MB in size).
> I could read it to a LOB/table/buffer/whatever, modify few bytes and
> write it back to the file in its entirety.
> But this is rather unacceptable solution - I would rather imagine I open
> a file, set a position, write few bytes at this position (adding or
> eventually replacing some bytes on specified length), close a file.
>
> I tried fseek, but it works in the Read-like mode only, as I get
> ERROR at line 1:
> ORA-29283: invalid file operation
> ORA-06512: at "SYS.UTL_FILE", line 1219
> ORA-06512: at "REMS.WRITE_AT", line 16
> ORA-06512: at line 1
>
>
> Regards
> Remigiusz
>
> --
> Pole nakazi
>
> ----------------------------------------------------------------------
> Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
> pos : DBA at DIiUSI
> addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
> phone : +48 58 667 17 43
> mobile: +48 602 42 42 77
> Nordea Bank Polska S.A. z siedzib± w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
> wpisan± do Rejestru Przedsiêbiorców Krajowego Rejestru S±dowego pod
> numerem: 0000021828,
> dla której dokumentacjê przechowuje S±d Rejonowy Gdañsk - Pó³noc w Gdañsku,
> VIII Wydzia³ Gospodarczy Krajowego Rejestru S±dowego,
> o kapitale zak³adowym i wp³aconym w wysoko¶ci: 227.593.500,00 z³otych,
> NIP: 586-000-78-20, REGON: 190024711--
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l