oracle external table issue [message #663358] |
Wed, 31 May 2017 09:08 |
|
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
|
|
|
|
|
|
|
|