Search Results

Even dynamicaly you have clues on the filname you are looking for, use what you know will always be in the file names...
You know that the desired files will always end by .dat only many other files...

ls -l TE*_DATA_*.dat

Well you look for what they have in common:
_TEST_DATA_ and .dat
so e.g.

ls -al *_TEST_DATA_*.dat |more

I think that table will not be accessible for your DB user.

If you are interested in getting the DB instance an alternate approach would be:
select ora_database_name from dual;

split -d -l 10 filename filename_split_
tar -cf filename_archive.tar filename_split_*
uuencode filename_archive.tar filename_archive.tar | mailx -s "Subject" user@domain.com

The code seems to be fine. Have you saved the file with a windows editor?

Using an array for this is kind of overkill. If you just want to read lines one by one, read lines one by one.

A=0
while read -r LINE
do
echo mv "$LINE" "./line_test_${A}.txt"
...