Re: PLSQL - Find out new directories used by an instance

kydongau wrote:

> Hi,
>
> Has anyone had any PLSQL codes to check for datafiles that are not in
> a defined set of directories. ie. there is a table that contains all
> the directories the instance has datafiles in. The PLSQL code checks
> each of these directories against all file_name in dba_data_files,
> displays datafiles that are found in the new directories.
>
> I can do this using extenal programs, I am only interested in PLSQL
> solution here.
>
> Thanks,
> Ky

Why not something based on this?

SELECT ...
FROM dba_data_files
WHERE INSTR(file_name, test_string) = 0;

Then just test each string you want in a loop recording the results in a global temp table or an array.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)