Home » SQL & PL/SQL » SQL & PL/SQL » search file from system (10.2.0.3.0)
search file from system [message #366190] Fri, 12 December 2008 01:12 Go to next message
mamalik
Messages: 270
Registered: November 2008
Location: Pakistan
Senior Member

Dear

May i search a file from my computer using a oracle procedure.

for example i have a file abc.fmb stored in various folders on my computer. i want to find out all folders which contain it and i also want to find out last modified file.


Best Regards.
Asif.
Re: search file from system [message #366196 is a reply to message #366190] Fri, 12 December 2008 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, you can't.
Why people want to use Oracle as file or file system manager. Oracle is a RDBMS, Relational DataBase Management System. It manages data not files or file systems.
Do you ask Windows or Unix if it selects in Oracle database?

Regards
Michel
Re: search file from system [message #366267 is a reply to message #366190] Fri, 12 December 2008 09:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not directly as Michel mentioned.

However, if you want to configure your database to accommodate for this functionality, you may be able to consider Oracle Secure Enterprise Search, Oracle Ultra Search or WebDAV.
Re: search file from system [message #366313 is a reply to message #366267] Fri, 12 December 2008 14:12 Go to previous message
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
Senior Member
You can also use a java stored procedure that can be called from Oracle to read your directory information and load it into Oracle tables, then search them, but that would certainly be doing things in a roundabout way. You can also run an operating system command from oracle through java. Why do you feel that you need to access this sort of information through an Oracle application? Is there some legitimate business requirement for which there might be a better way?

Previous Topic: Split Partition with Subpartition
Next Topic: How send a mail dynamically
Goto Forum:
  


Current Time: Wed Feb 19 13:16:00 CST 2025