Sponsored Content
Top Forums Shell Programming and Scripting Scripts for exporting backup from selected tables of Oracle DB Post 302881768 by amirzargaran on Wednesday 1st of January 2014 01:10:09 AM
Old 01-01-2014
dear parvin.
did i must to run this commands on centos bash ?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Crontab job for exporting a Oracle database

Could someone give me a hint how to get or write such a job ? I want to schedule a Oracle export using the crontab, I really do not know how to do this. Concreet: How do I write such a script ? Thanks for your help. (1 Reply)
Discussion started by: c.d.israel
1 Replies

2. Solaris

exporting a dmp file (oracle)from unix

i want to export a database (full schema) so that I can import the database to a windows 2000 server. The database is sitting on a unix-sun solaris box ver 8.. What are the commands... I am a bit rusty at unix at the moment! Cheers E (4 Replies)
Discussion started by: etravels
4 Replies

3. UNIX for Dummies Questions & Answers

finding out tables not used in scripts.

Hi all, Please see my requirement and post me asap. Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence... (7 Replies)
Discussion started by: Vasundhara
7 Replies

4. Shell Programming and Scripting

use shell scripts to update tables from databases

Hi I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility... (0 Replies)
Discussion started by: wannabegeek
0 Replies

5. Shell Programming and Scripting

tables in scripts

Hi , I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1, t3= t1 - t2 t3= t1 - t2 I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies

6. Shell Programming and Scripting

Reading data from multiple tables from Oracle DB

Hi , I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code : X=`sqlplus -s user/pwd@DB <<eof select col1 from table1; EXIT; eof` echo $X>myfile Can anyone... (2 Replies)
Discussion started by: net
2 Replies

7. Solaris

Exporting DHCP to backup server

Hi just looking for some advise on the best way to set-up a passive dhcp server in solaris. Was thinking of exporting the dhcp data/macros etc to a separate server to use as a backup that will be activated when the main dhcp server goes down Any hints/tips etc greatly appreciated (1 Reply)
Discussion started by: eeisken
1 Replies

8. Shell Programming and Scripting

KSH - How to call different scripts from master scripts based on a column in an Oracle table

Dear Members, I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc. I would like to create a script which will will call other scripts based on the request action. Can we directly read from the REQUEST_ACTION... (2 Replies)
Discussion started by: Yoodit
2 Replies

9. Programming

Oracle 10g tables dumps

HI All, I am using Oracle 10g . Want to take dumps(.dmp log) from many tables with where clause having same schema. ex : TB_MTH_ORA_CAB "WHERE TRUNC(dw_entry_dt )= TO_DATE('01-JAN-2011')" TB_AM_AT_OSS_MAT "WHERE TRUNC(dw_entry_date )>= TO_DATE('01-JAN-2011') AND TRUNC(dw_entry_date )<=... (4 Replies)
Discussion started by: Perlbaby
4 Replies

10. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
scl(1)							      General Commands Manual							    scl(1)

NAME
scl - Setup and run software from Software Collection environment SYNOPSIS
scl <action> <collection1> [<collection2> ...] <command> scl <action> <collection1> [<collection2> ...] -- <command> scl {-l|--list} [<collection1> <collection2> ...] DESCRIPTION
This manual page documents scl, a program which is an utility for running software packaged as a Software Collection. scl utility allows to execute an application which is not located in the filesystem root hierarchy but is present in an alternative loca- tion. This application can still use and benefit from software installed in the root filesystem. In order to let an application be visible to the system one has to use scl utility as an interface. <action> is a script name to execute in a bash environment before the application itself takes in executed. Currently only enable scriptlet is mandatory which is needed to update search paths, etc. One can enable more Software Collections if needed and therefore one can use multiple collections which are enabled by the left-right order as present on scl command-line. <command> is an arbitrary command or set of commands to execute within the Software Collection environment enabled. Control is returned back to the caller with the original environment as soon as the command finishes. If <command> is '-' (dash) then it is read from the stan- dard input. Note: if you use <command> consisting of multiple arguments, you either need to use quotes or the -- command separator. Everything that follows the separator will be considered a command or its argument. Note: some commands modify user environment in some way. Those commands may potentially break SCLs, as their activation also usually depends on env. modification as well. Typical examples of such commands are su and sudo. Every collection modifies the environment differ- ently, thus more details may be found in the documentation of the particular collection. OPTIONS
-l, --list Lists all installed Software Collections on the system. -l, --list <collection1> <collection2> ... If a collection name is specified then list of installed packages belonging to the collection is listed. EXAMPLES
scl enable example 'less --version' runs command 'less --version' in the environment with collection 'example' enabled scl enable foo bar bash runs bash instance with foo and bar Software Collections enabled cat my_command | scl enable baz - run set of commands listed in my_command file in the environment with baz Software Collection enabled scl -l list all installed collections scl -l example list all packages within example collection AUTHOR
scl was written by Jindrich Novy <jnovy@redhat.com> and Jan Zeleny <jzeleny@redhat.com> scl(1)
All times are GMT -4. The time now is 06:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy