SQL*Loader - wildcard character [message #676806] |
Thu, 18 July 2019 10:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b184c6921e5c4f7b3789c3351151fc77?s=64&d=mm&r=g) |
clockdva
Messages: 8 Registered: July 2019
|
Junior Member |
|
|
is it possibile to use a wildcard character to indicate the file?
something like
"load data
infile 'myfile*'"
to load a file with name 'myfile2001'
another information: i'm working on Linux e my file has no extension, thanks and sorry for my bad english
|
|
|
|
|
|
Re: SQL*Loader - wildcard character [message #676813 is a reply to message #676809] |
Thu, 18 July 2019 14:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
clockdva wrote on Thu, 18 July 2019 20:22in this way it works but not with a file without extension, thanks
...
Linux does not care about extension, this is not a Unix/Linux notion, dot (".") is like any other characters in the file name for Linux.
So, explain how it does not work.
[Updated on: Thu, 18 July 2019 14:26] Report message to a moderator
|
|
|
|
|
|
|
Re: SQL*Loader - wildcard character [message #676820 is a reply to message #676818] |
Fri, 19 July 2019 06:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b184c6921e5c4f7b3789c3351151fc77?s=64&d=mm&r=g) |
clockdva
Messages: 8 Registered: July 2019
|
Junior Member |
|
|
thanks
the last question: i think it's impossibile to give some params to the code in the file .ctl; i need something as:
(this is my .ctl file)
load data
REPLACE
into table $MY_TABLE
...
where $MY_TABLE is the param that i give from the .sh script
do you confirm that it is impossibile?
i have remedied creating the .ctl file directly in the .sh file:
(this is my .sh file)
readonly SQLLDR_CTL="load data
REPLACE
into table $MY_TABLE..."
echo "$SQLLDR_CTL" > "file.ctl"
[Updated on: Fri, 19 July 2019 06:27] Report message to a moderator
|
|
|
|
|
|
Re: SQL*Loader - wildcard character [message #676835 is a reply to message #676826] |
Sat, 20 July 2019 10:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/b184c6921e5c4f7b3789c3351151fc77?s=64&d=mm&r=g) |
clockdva
Messages: 8 Registered: July 2019
|
Junior Member |
|
|
BlackSwan wrote on Fri, 19 July 2019 11:09You could maintain a single static file name used by SQLLDR & manipulate the actual data being loaded by using softlink to point various different OS files
thanks
|
|
|