08-01-2006
help for writing shell script to export table data
Hi All,
I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data).
The tables list is not static, and those are selecting through dynamic sql
query. Can any body help how to write this shell script.
Thanks,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
2. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
3. Shell Programming and Scripting
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies
4. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
5. Shell Programming and Scripting
i have a Oracle table like
col1 col2
---- -----
a 1
b 2
c 3
when i write a script for it , it gives me all the data in one column.
Please give me the solution which gives the exact result like we see in sql editors.
for a in `echo "
set feedback off;
set pagesize 40;... (1 Reply)
Discussion started by: ss135r
1 Replies
6. 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
7. Shell Programming and Scripting
Hi,
I want to write a shell script which connect to my database with the following credentials :
User name : user
PWD : rap_user_1
Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID : PTNC1
Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
8. Shell Programming and Scripting
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
9. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
10. Programming
Hi, I am complete new to C programming and shell scripting. I just wrote a simple C code to calculate integral using trapezoid rule. I am prompting user to pass me No. of equally spaced points , N , upper and lower limit. My code looks as follows so far:
#include<stdio.h>
#include<string.h>... (2 Replies)
Discussion started by: bjhjh
2 Replies
LEARN ABOUT LINUX
nissetup
nissetup(1M) System Administration Commands nissetup(1M)
NAME
nissetup - initialize a NIS+ domain
SYNOPSIS
/usr/lib/nis/nissetup [-Y] [domain]
DESCRIPTION
nissetup is a shell script that sets up a NIS+ domain to service clients that wish to store system administration information in a domain
named domain. This domain should already exist prior to executing this command. See nismkdir(1) and nisinit(1M).
A NIS+ domain consists of a NIS+ directory and its subdirectories: org_dir and groups_dir. org_dir stores system administration informa-
tion and groups_dir stores information for group access control.
nissetup creates the subdirectories org_dir and groups_dir in domain. Both subdirectories will be replicated on the same servers as the
parent domain. After the subdirectories are created, nissetup creates the default tables that NIS+ serves. These are auto_master,
auto_home, bootparams, cred, ethers, group, hosts, mail_aliases, netmasks, networks, passwd, protocols, rpc, services, and timezone. The
nissetup script uses the nistbladm(1) command to create these tables. The script can be easily customized to add site specific tables that
are created at setup time.
This command is normally executed just once per domain.
While this command creates the default tables, it does not initialize them with data. This is accomplished with the nisaddent(1M) command.
It is easier to use the nisserver(1M) script to create subdirectories and the default tables.
OPTIONS
-Y Specify that the domain will be served as both a NIS+ domain as well as an NIS domain using the backward compatibility flag. This
will set up the domain to be less secure by making all the system tables readable by unauthenticated clients as well.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWnisu |
+-----------------------------+-----------------------------+
SEE ALSO
nis+(1), nismkdir(1), nistbladm(1), nisaddent(1M), nisinit(1M) nisserver(1M), attributes(5)
NOTES
NIS+ might not be supported in future releases of the SolarisTM Operating Environment. Tools to aid the migration from NIS+ to LDAP are
available in the Solaris 9 operating environment. For more information, visit http://www.sun.com/directory/nisplus/transition.html.
SunOS 5.10 13 Dec 2001 nissetup(1M)