We have almost 45,000 data files created by a script daily. The file names are of format-ODS.POS.<pharmacyid>.<table name>.<timestamp>.dat. There will be one data file like this for each pharmacy and each table.(Totally around 45,000)
The requirement is to create a control file for each pharmacy id with file name, No.of rows , table name, timestamp and MD5 value.
The data files look like this -
The requirement is to create a control file for each pharmacyid
Controlfile 1 -> for pharmacy id - ABC89
Control file 1 (ODS.POS.<Pharmacyid>.timestamp.ctl )should contain the filename, no.of rows, table name, time stamp and MD5 value for the below files.
Control file 2->for pharmacy id - AEC12
Control file 2 ((ODS.POS.<Pharmacyid>.<timestamp>.ctl )should contain the filename, no.of rows, table name, time stamp and MD5 value for the below files.
can somebody help on this?
Thanks
Maya
Last edited by Scott; 08-02-2010 at 06:16 AM..
Reason: Code tags, please...
Hi,
I have many files but with only 2 names , I want to load the data of that file into database through sqlldr with single control file. how can i do that ?????
Example:
switch_file
switch_file
billing_file
billing_file
now these files should be loaded into same database but different... (1 Reply)
Delete
---- Original post, restored by mod after being deleted by abhilashnair ----
I have a requirement where, I need to create a control file which will have 3 columns in the header row as below:
Filename
Count
Checksum
This above control file has to contain metadata as above... (2 Replies)
Hi,
I have a file with usernames, and the comment section, e.g :
Data removed by request of sanchitadutta91, 20 May 2020
I need to add these users into a server. Is it possible to use a script to create the users, together with the comment ?
From the commandline to add one user, the... (2 Replies)
Hi members,
I have a file with lots of text like this:
asdsfkm
dfsfomnow i want to extract only the rows with HUMAN as its 1st column
for this I used :
ruby -ne 'print if /^Human/; exit if /^TER/' $line | awk 'print $1, "\t"$2, "\t"$3, "\t"$4, "\t"$5}' >$line"new"
This is creating a file... (1 Reply)
Hi,
I am working on setup a environment where only a specific user can upload the builds on htdocs of apache.
Now i want that a specific user can copy the builds on htdocs folder.
I created a group "deploy" and assign user1 and user2 to this group.
On Apache side i mentioned User=deploy... (3 Replies)
Hi,
I'm the root user on my computer, but I'm writing a script that does a lot of file handling. Every time I create a file or directory it automatically requires root privileges. Is there a way I can just create a file that the user can access without a password?
For example in my script I... (20 Replies)
We have created ACL's to allow two differnet groups to access some directories. You can see output from getfacl below.
group::rwx
group:rbauser:r--
The original group has full access, the secondary group has read only. However users in the secondary group can't see the directories. Think this... (1 Reply)
What is a supplementary group and how do you make a supplementary group for members of a team? Thanks in advance.
---------- Post updated 05-10-11 at 12:09 PM ---------- Previous update was 05-09-11 at 10:08 PM ----------
anybody? (1 Reply)
I have a directory named Project.I have a control file which contains valid list of files.I would like list the files from directory Project which contains files other than listed in the control file.
Sample control file:
TEST
SEND
SFFFILE
CONTL
The directory contains followign... (15 Replies)