oracle external table issue [message #663358] |
Wed, 31 May 2017 09:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/334c3263054529b46354eb9aded2c0cc?s=64&d=mm&r=g) |
POGAKU_SANTHOSH
Messages: 39 Registered: April 2017
|
Member |
|
|
I have an ORACLE EXTERNAL TABLE which loads the files data from a path . But the file name which is present in the path will be modified for every 5 minutes only the time stamp of the file will be changed in an regular intervals. Sample file name : 'DATA_31052017032525.txt'.
--The highlighted path will be changed in regular intervals.
How can i handle this scenario in the ORACLE EXTARNAL TABLE SCRIPT instead of modifying the file name in the script of the oet table for every 5 minutes.
[Updated on: Wed, 31 May 2017 09:10] Report message to a moderator
|
|
|
|
|
|
|
|