-- Script for Finding Invalid Directories.
-- Create a test file and check for the status
declare
f utl_file.file_type;
BEGIN
FOR X IN ( SELECT * FROM DBA_DIRECTORIES WHERE OWNER= 'SYS' ) LOOP
BEGIN
f := utl_file.fopen(x.directory_name,'madhu_test.txt','W');
IF utl_file.is_open(f) THEN
UTL_FILE.fclose(f);
UTL_FILE.fremove(x.directory_name,'madhu_test.txt');
end if;
EXCEPTION
WHEN OTHERS THEN dbms_output.put_line(x.directory_name || ' -- ' || x.directory_path || ' is invalid');
END;
END LOOP;
END;
/
Tuesday, June 30, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment