Home » Infrastructure » Unix » Re: UTL_FILE on linux
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;

----------------------------------------------------------------------
Previous Topic: Re: Installing Oracle 8.1.7 on Redhat Linux 7.1
Next Topic: Re: Installing Oracle 8.1.6 on Redhat Linux 7.1
Goto Forum:
  


Current Time: Tue Sep 29 04:48:11 CDT 2020