| Re: UTL_FILE on linux [message #97100] |
Sun, 02 December 2001 22:09 |
Volkmar v. Willert
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
perhaps you should shutdown and restart the database
So I add
utl_file_dir = /home/oracle/data/tmp
in initXXXX.ora
and shutdown and startup the oracle database and it works
see axample sql:
DECLARE
fhandle utl_file.file_type;
CURSOR c1 IS
SELECT file_name,TABLESPACE_NAME
FROM dba_data_files;
emp_rec c1%ROWTYPE;
BEGIN
fhandle:= utl_file.fopen('/home/oracle/data/tmp','db.tmp','w');
FOR file in c1
LOOP
utl_file.put_line(fhandle,file.file_name || ' ' || file.TABLESPACE_NAME );
dbms_output.put_line(file.file_name || ' ' || file.TABLESPACE_NAME );
END LOOP;
utl_file.fclose(fhandle);
END;
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
