10-25-2010
Are you asking about Shell or Oracle or something else?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have 20000 numbers present in a file in each line like
25663,
65465,
74579,
56446,
..
..
I have created a table in db with single number column in it.
create table testhari (no number(9));
I want to insert all these numbers into that table. how can i do it?
can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies
2. Shell Programming and Scripting
Hi All,
I need to load records from oracle table XYZ to a flat file say ABC.dat.
could any one tell me how do i do this in UNXI,
Regards
Ann (1 Reply)
Discussion started by: Haque123
1 Replies
3. Shell Programming and Scripting
Hi,
I am loading data in the database table through sqlldr. I have to find total records loaded from sqlldr log file and store it in a variable in my script. How do I get it?
Thank you. (3 Replies)
Discussion started by: mrpranab
3 Replies
4. Shell Programming and Scripting
Hi,
Script copies records of two tables into another tables for backup before using oracle's import utility to restore from backup.
Now, suppose if the import utility fails then the script will again copy those records from the backup table to the original ones.
How to check whether all... (2 Replies)
Discussion started by: milink
2 Replies
5. Shell Programming and Scripting
Good Morning/Afternoon All,
I am having some trouble creating a variable called "total" to display the sum of the values in a specific field, $6 for example.
The data I am working on is in the following form:
John Doe:(555) 555-5555:1:2:3
Jane Doe:(544) 444-5556:4:5:6
Moe Doe:(654)... (2 Replies)
Discussion started by: SEinT
2 Replies
6. Shell Programming and Scripting
I am doing a loading process. I am loading data from a Oracle source to Oracle target.
For example there is an SQL statement:
Insert into emp_1
Select * from emp_2 where deptno=20;
In this case my source is emp_2 and loading into my target table emp_1. This process is automated. Now I... (3 Replies)
Discussion started by: karthikkasarla
3 Replies
7. Shell Programming and Scripting
Dear All,
I have table files with different measurements for the same sensors. The first column indicate the sensor (7 different sensors and 16 measurements in the example below). I would like to find the best measurement for each sensor. The best measurement is determined by the higher value of... (10 Replies)
Discussion started by: GDC
10 Replies
8. Shell Programming and Scripting
Hi,
Can any one help me...
the records are not deleting when I run the below script.
But if I issue the same delete command manually, the records are getting deleted.
script:
#!/bin/ksh
USAGE_STRING="USAGE $0 "
if
then
echo "SORRY you need to be user 'mqm'. Only 'mqm' has... (5 Replies)
Discussion started by: zxcjggu708
5 Replies
9. Shell Programming and Scripting
Hello Friends,
I've been trying to calculate total number of a certain match in multiple data records files (DRs).
Let say I have a daily created folders for each day since the beginning of july like the following
drwxrwxrwx 2 mmsuper med 65536 Jul 1 23:59 20150701
drwxrwxrwx 2 mmsuper... (1 Reply)
Discussion started by: EAGL€
1 Replies
10. Shell Programming and Scripting
111AKKK|SHA|20|25
111|AKKK|SHA|15|35
112|ABC|FL|25|45
112|ABC|FL|15|15
115|AKKK|ASH|10|15
115|AKKK|ASH|20|20
112|ABC|FL|25|20
115|AKKK|ASH|30|35
111|AKKK|SHA|10|45
112|ABC|KL|15|15
112|ABC|KL|20|25
115|AKKK|ASH|30|35
please write a shell script
output should be below mentioned... (26 Replies)
Discussion started by: udhal
26 Replies
runacct(1M) runacct(1M)
NAME
runacct - run daily accounting
SYNOPSIS
[mmdd[state]]
DESCRIPTION
runacct is the main daily accounting shell procedure. It is normally initiated via cron(1M). runacct processes connect, fee, disk, and
process accounting files. It also prepares summary files for prdaily or billing purposes.
runacct takes care not to damage active accounting files or summary files in the event of errors. It records its progress by writing
descriptive diagnostic messages into When an error is detected, a message is written to mail (see mail(1), mailx(1), or elm(1)) is sent to
and and runacct terminates. runacct uses a series of lock files to protect against re-invocation. The files and are used to prevent
simultaneous invocation, and is used to prevent more than one invocation per day.
runacct breaks its processing into separate, restartable states using to remember the last state completed. It accomplishes this by writ-
ing the state name into runacct then looks in to see what it has done and to determine what to process next. states are executed in the
following order:
Move active accounting files into working files.
Verify integrity of
file, correcting date changes if necessary.
Produce connect session records in
format.
Convert process accounting records into
format.
Merge the connect and process accounting records.
Convert output of
chargefee into format and merge with connect and process accounting records.
Merge disk accounting records with connect, process, and fee accounting
records.
Merge the daily total accounting records in
with the summary total accounting records in
Produce command summaries.
Any installation-dependent accounting programs can be
included here.
Cleanup temporary files and exit.
To restart runacct after a failure, first check the file for diagnostics, then fix up any corrupted data files such as or The files and
file must be removed before runacct can be restarted. The argument mmdd is necessary if runacct is being restarted, and specifies the
month and day for which runacct will rerun the accounting. Entry point for processing is based on the contents of to override this,
include the desired state on the command line to designate where processing should begin.
EXAMPLES
To start runacct.
To restart runacct.
To restart runacct at a specific state.
WARNINGS
Normally it is not a good idea to restart runacct in its state. Run manually, then restart via:
If runacct failed in its state, remove the last file because it will not be complete.
FILES
SEE ALSO
mail(1), acct(1M), acctcms(1M), acctcom(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), cron(1M), fwtmp(1M), acct(2), acct(4),
utmp(4).
STANDARDS CONFORMANCE
runacct(1M)