| Re: UTL_FILE on linux [message #97084] |
Tue, 20 November 2001 09:36  |
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  |
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 |
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 |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
