ORACLE directory object - path_name

[Adalbert]

Zdravím,

lze v prvku oracle directory pouzit v casti path_name sitove umisteni?
Resp zadat ho urcite lze.
Zajima me vsak, zda dokaze oracle ukladat pomoci balicku UTL_FILE na nejake sitove uloziste, nebo jenom na local.

Pokud totiz zadam cestu na sit, nikoliv na lokal koncim na:

SQL Error: ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
ORA-04088: error during execution of trigger 'trigger_name'
29283. 00000 - "invalid file operation"
*Cause: An attempt was made to read from a file or directory that does
not exist, or file or directory access was denied by the
operating system.
*Action: Verify file and directory access privileges on the file system,
and if reading, verify that the file exists.

Osobne se domnivam, ze cestu na siti oracle proste neskousne. Pokud ano, jake opravneni musim souboru na siti udelit?
Vyzkousel jsem uz co se da.

Pokud se pres UTL_FILE exportovat na sitove uloziste neda, prosim o radu, zda li toho lze primo z oracle procedury dosahnout jinak.

Diky

PS: jeste pro upresneni: Oracle 10g XE

[Reklama]