Home » Infrastructure » Unix » Re: UTL_FILE on linux
Re: UTL_FILE on linux [message #97084] Tue, 20 November 2001 09:36 Go to next message
Oscar
Messages: 6
Registered: November 2001
Junior Member
Hi,

I have the same error, that you but I don't know to solve it. Have you solved it?
If you know to solve it please you can tell me it.

Thanks

----------------------------------------------------------------------
Re: UTL_FILE on linux [message #97472 is a reply to message #97084] Mon, 03 June 2002 02:35 Go to previous messageGo to next message
Sreekanth Chenichery
Messages: 1
Registered: June 2002
Junior Member
Hi friends,

Even i met across the same problem.
I edited init.ora file by entering utl_file_dir variable and assigned a proper directory to the same. Still its giving same ora-06512 error.

Please let me know if any one solved the problem.

Thanks in advance
Sreekanth.
Re: UTL_FILE on linux [message #97604 is a reply to message #97472] Thu, 05 September 2002 19:28 Go to previous messageGo to next message
Thomas Lai
Messages: 1
Registered: September 2002
Junior Member
I encountered this in NT. Found out that the problem is caused by another software locking the file which Oracle writing to. We turned the software off and the error goes away.
Re: UTL_FILE on linux [message #97625 is a reply to message #97084] Mon, 23 September 2002 23:45 Go to previous message
Sravana Kumar BJA
Messages: 1
Registered: September 2002
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: Oracle 8i on SCO Unix
Next Topic: Re: script for creating 8.0.6 database on unix digital !
Goto Forum:
  


Current Time: Thu Mar 28 17:30:22 CDT 2024