<div>
Not by any sql or pl/sql means.<br />
<br />
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
</div>


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

<div>
an easy substitute would be to set up a cron job to send &quot;ls -alF&quot; (or whatever options you want) output to a file periodically and then use an external table to read that. &nbsp;The cron job can't have granularity lower than one minute though.
</div>


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.

<div>
You can get the created time for the Oracle table definition from dba_objects.
</div>


You can get the created time for the Oracle table definition from dba_objects.

<div>
No, dba_objects will only show you the date the external table object was created or modified. &nbsp;It does not show any information about the underlying file
</div>


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

<div>
yes, I agree,<br />
<br />
&nbsp;maybe I misunderstood the question, but I thought the question was referring to the create/modify time of the file not the table.<br />

</div>


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.


<div>
how does &nbsp; <a href="http:#35161152" rel="ugc">http:#35161152</a>&nbsp; &nbsp;answer the question?
</div>


how does   http:#35161152 [http:#35161152]   answer the question?

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Cheers<br />
Sachin
</div>
</div>


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

Unix file creation date from Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.