Unix file creation date from Oracle

There are few csv files on OS which we are using in external tables. Can I get the time of creation/modify from Oracle prompt.

Cheers
Sachin
sachin_dbaAsked:
Who is Participating?
 
MrNedConnect With a Mentor Commented:
@sdstuber - yes, hence the "Oracle table definition".
0
 
sdstuberCommented:
Not by any sql or pl/sql means.

If you have a java stored procedure (you would have to write one) you could potentially do it but then you would also need to grant java permissions on that directory to read the files as well as execute permission on the java procedure and a pl/sql wrapper for the java routine
0
 
sdstuberCommented:
an easy substitute would be to set up a cron job to send "ls -alF" (or whatever options you want) output to a file periodically and then use an external table to read that.  The cron job can't have granularity lower than one minute though.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
MrNedCommented:
You can get the created time for the Oracle table definition from dba_objects.
0
 
sdstuberCommented:
No, dba_objects will only show you the date the external table object was created or modified.  It does not show any information about the underlying file
0
 
sdstuberCommented:
yes, I agree,

 maybe I misunderstood the question, but I thought the question was referring to the create/modify time of the file not the table.
0
 
sachin_dbaAuthor Commented:
thanks
0
 
sdstuberCommented:
how does   http:#35161152   answer the question?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.