Hi ,
I am having one situation in which I need to run some simple unix commands after doing "chroot" command in a shell script. Which in turn creates a new shell.
So scenario is that
- I need to have one shell script which is ran as a part of crontab
- in this shell script I need to do a... (2 Replies)
Hi Experts,
Can anyone help me to write shell script for taking backup with RMAN in oracle 9i or suggests me any site which has this kind of scripts
Thanks
shaan (1 Reply)
Hi,
I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input.
I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Dears,
I'm new in shell scripting and i need your help, i would like to know how can i create a script to ftp to a certain unix/linux machine/server IP address and get a file for example without user intervention? How can i force the script to use a certain username and password to access this... (4 Replies)
When my script deals with large input files like 22Gb or 18 GB the basic commands like sort or join fails when run from inside the shell scripts. Can there be any specific reason for this?
For e.g.
sort -u -t "," -k1,1 a.csv > a.csv.uniq"
sort -u -t "," -k1,1 b.csv > b.csv.uniq"
The... (3 Replies)
I would like to execute a commands in four different servers through ssh at a single instance(simultaneously).
Below are the details with examples,
ssh user1@server1 "grep xxxx logs"
ssh user1@server2 "grep xxxx logs"
ssh user1@server3 "grep xxxx logs"
Each statement will take some... (4 Replies)
Hi
I have a program
int main(int srgc, char *argv)
{
for(int i=1; i<50; i++)
{
system("dd if=/dev/zero of=file$i bs=1024 count=$i");
}
return 0;
}
My doubt is how to use the "$i" value inside C code
Please help (2 Replies)
Hi,
I have the following RMAN incremental shell script:
# !/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ORCL
export PATH=$PATH:${ORACLE_HOME}/bin
rman target=/ << EOF
run {
allocate channel d1 type disk FORMAT... (3 Replies)
Hi,
I have a bash script to run many system commands on CentOS machine, but I am puzzled by some commands had no effect on parent environment.
For example, I want to refresh the desktop xdg menu when some processes added or deleted items from desktop xdg menu. If I run "killall gnome-panel"... (4 Replies)
Discussion started by: hce
4 Replies
LEARN ABOUT DEBIAN
mdb-schema
MDBTools(1)MDBTools(1)NAME
mdb-schema - Generate schema creation DDL
SYNOPSIS
mdb-schema [options] database [backend]
DESCRIPTION
mdb-schema is a utility program distributed with MDB Tools.
It produces DDL (data definition language) output for the given database. This can be passed to another database to create a replica of the
original access table format.
OPTIONS -T <table>, --table <table>
Single table option. Create schema for this table only. Default is to export all tables.
-N namespace
Prefix identifiers with namespace.
--drop-table
Issue DROP TABLE statement.
--no-drop-table
Don't issue DROP TABLE statement. This is the default.
--not-null
Issue NOT NULL constraints. This is the default.
--no-not-null
Don't issue NOT NULL constraints.
--default-values
Issue DEFAULT values.
--no-default-values
Don't issue DEFAULT values. This is the default.
--not-empty
Issue CHECK <> '' constraints.
--no-not-empty
Don't issue CHECK <> '' constraints. This is the default.
--indexes
Export INDEXes. This is the default.
--no-indexes
Don't export INDEXes.
--relations
Export foreign keys constraints. This is the default.
--no-relations
Don't export foreign keys constraints.
backend
Specifies target DDL dialect. Supported values are access, sybase, oracle, postgres, and mysql. If not specified the generated DDL
will be in access format.
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
NOTES HISTORY
mdb-schema first appeared in MDB Tools 0.1.
SEE ALSO gmdb2(1)mdb-export(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-header(1)mdb-parsecsv(1)mdb-tables(1)AUTHORS
The mdb-schema utility was written by Brian Bruns and others.
BUGS
Relationships and other features may not be supported by all databases. Access datatypes are mapped to their closest counterparts in the
target backend. This may not always yield an exact fit.
0.7 13 July 2013 MDBTools(1)