03-22-2007
Well, i would check the log fisrt (exp_13032007.log) and eventually ask the dba to find and kill the export session (inside oracle itself) you ran manually
But it will be just fine if You could just schedule a database restart (i guess! im not a dba but most of the time it works
)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
3. Solaris
While i am trying to run a script in which it calls an executable(binary code)processes a file using the data in database.
But while running the script the following error is occured.
"permission to access this database was denied
<err-0025-0191>re /ds1/nrms_r.db9 while looking up... (0 Replies)
Discussion started by: vamshikrishnab
0 Replies
4. Shell Programming and Scripting
Hello Gurus,
I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
1 Replies
5. UNIX for Advanced & Expert Users
Hi all guys,
how you can read in thread title, I'm deploying a bash script in which I have to export some variables inside it.
But (I think you know) the export command works only inside the script and so, on exit command, the variables aren't set like I set inside the script.
Consequently in... (8 Replies)
Discussion started by: idro
8 Replies
6. Shell Programming and Scripting
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies
7. Programming
Hi.
I have two text files(tables) which include some information and I want to make some query codes using them.
First of all, I want to create bash script that read this two tables, create/open database and insert data from files into database.
#!/bin/bash
while read line; do
... (1 Reply)
Discussion started by: rlaxodus
1 Replies
8. Shell Programming and Scripting
Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies
9. Shell Programming and Scripting
i have a script inside which i have generated a background job which will run another script.
How do i export the variables from parent script to the child script which wil run in the background .
a.sh:-
export tmpdir="/usr/tmp"
nohup b.sh&
b.sh:-
echo $tmpdir
But... (1 Reply)
Discussion started by: millan
1 Replies
10. Shell Programming and Scripting
Hi all
I am trying to create a script that takes a password input then writes that to a tmp file and puts that tmp file path in my env as a var.
It does everything but export the my env and I am unsure why.
I am using Ubuntu 12.4
#!/bin/bash
read -s -p "Enter Password: " gfpassword... (5 Replies)
Discussion started by: koikoi
5 Replies
LEARN ABOUT NETBSD
lastlogin
LASTLOGIN(8) BSD System Manager's Manual LASTLOGIN(8)
NAME
lastlogin -- indicate last login time of users
SYNOPSIS
lastlogin [-nrt] [-f filename] [-H hostsize] [-L linesize] [-N namesize] [user ...]
DESCRIPTION
lastlogin will list the last login session of specified users, or for all users by default. Each line of output contains the user name, the
tty from which the session was conducted, any hostname, and the start time for the session.
If multiple users are given, the session information for each user is printed in the order given on the command line. Otherwise, information
for all users is printed, sorted by uid.
lastlogin differs from last(1) in that it only prints information regarding the very last login session. The last login database is never
turned over or deleted in standard usage.
The following options are available:
-f filename
Process input from filename. If the file ends with an ``x'', then it is assumed that it is a lastlogx(5) file, else it is assumed to
be a lastlog(5) file.
-H hostlen
Set the field width for host output to hostlen characters.
-L linelen
Set the field width for line output to linelen characters.
-N namelen
Set the field width for name output to namelen characters.
-n Attempt to print numeric host addresses. This option is only supported with lastlogx(5) format files.
-r Reverse the order of the sort.
-t Sort by last login time (most recent first.)
FILES
/var/log/lastlogx default last login database
/var/log/lastlog compatibility last login database
EXAMPLES
lastlogin looks by default to the /var/log/lastlogx database, where some old programs that are not utmpx(5) aware might only write to
/var/log/lastlog. To look at the old database one can use:
lastlogin -f /var/log/lastlog
SEE ALSO
last(1), lastlog(5), lastlogx(5), ac(8)
AUTHORS
John M. Vinopal wrote this program in January 1996 and contributed it to the NetBSD project.
BSD
March 4, 2005 BSD