10-04-2006
Alter Table Shell Script
I want to add some columns to a existing tables through a shell script.
Please help.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all:
I want to write a script capable of reading specific rows and collumns of a table, into a variable.
Just imagine i have a file named table.dat which contains:
GENERAL INFORMATION
Col 1 Col2 Col3
1 1
2 2
3 3
4 4
What i want to do... (13 Replies)
Discussion started by: luiscarvalheiro
13 Replies
2. Shell Programming and Scripting
Hi folks,
I have a dual-boot Ubuntu/Windows machine and I wanted to create a script to change the menu.lst file so it will change the default boot partition (this is so I can reload the machine remotely and allow it to boot to the Windows partition).
Today I have to sudo cp a template file I... (1 Reply)
Discussion started by: ppucci
1 Replies
3. Shell Programming and Scripting
I am trying to truncate a table using below script. When I ran the script it runs fine but table was not truncated and the spool is empty. I am not sure what is wrong with pl/sql block.
#!/bin/ksh
# ----------------------------------------------------------------------
#
# Created by: XXXX... (2 Replies)
Discussion started by: gunaah
2 Replies
4. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
My first question pertains to the adding a book section, I'm unsure which command or conditional statement I... (0 Replies)
Discussion started by: Vitrophyre
0 Replies
5. Shell Programming and Scripting
Hi,
Can anyone tell me that, How to create table in Oracle database through shell script(ksh).
Table contains 3 fields,
1] Emp ID, String, primary key
2] Name, String
3] B Date, date.
Thanks in advance. (6 Replies)
Discussion started by: Poonamol
6 Replies
6. Shell Programming and Scripting
Hi,
i need a bit help. I must write a script with shell- and sed-commands, which reads a table from stdin and writes a html-table on stdout (so i can open it with a web browser). The number of columns must be a parameter for the script, so i can start it for example with: "./htmltab.sh 3... (3 Replies)
Discussion started by: scruffytramp
3 Replies
7. UNIX and Linux Applications
Hello,
I am newbie on mysql and trying to edit my database from terminal under linux.
What I need to do is to change the information written in a cell in table.
Let me explain what I tried:
$ mysql -u mysqluser -p
$ show databases;
$ USE catalogue;
$ show tables ;
$ select * from... (2 Replies)
Discussion started by: baris35
2 Replies
8. Homework & Coursework Questions
input file txt file
2000 1 name
2000 2 addr
2000 3 phone
2000 4 email
1000 1 name
1000 2 addr
1000 3 phone
1000 4 email
3000 1 name
3000 2 addr
3000 ... (4 Replies)
Discussion started by: senmatrix
4 Replies
LEARN ABOUT SUNOS
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)