Scripts for exporting backup from selected tables of Oracle DB Post: 302881764

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.

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

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...

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...

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

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...

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

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...

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 )<=...

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...

LEARN ABOUT CENTOS

ttmkfdir

TTMKFDIR(1)						      General Commands Manual						       TTMKFDIR(1)

NAME

       ttmkfdir - Utility to create fonts.scale files for truetype fonts

SYNOPSIS

       ttmkfdir [OPTION]

DESCRIPTION

	   Originally  written by Joerg Pommnitz, ttmkfdir is a tool to create valid and complete fonts.scale file from TrueType fonts. It is very
       useful when you plan to use a TrueType enabled font server that is based on the X11R6 sample implementation  (xfsft  for  instance).  Great
       care has been taken to correctly identify the encodings that a given TrueType font supports.

       The ttmkfdir comes with Red Hat Linux has experienced quite some modifications or improvements, include:

       - migration to FreeType 2 library

       - more accurate checking for big font files

       - support for both two X core font backends, Freetype and XTT

       - Truetype collection(ttc) font file support

       - additional CJK friendly features

       - bug fixes

OPTIONS

       Here is the detailed usage of Red Hat version of ttmkfdir.

       -h, --help
	      It shows the menus and combo box in iok UI

       -e, --encoding <encodings.dir>
	      ttmkfdir is doing its job by checking each TrueType font file against fontenc layer, please refer www.xfree86.org/current/fonts.html
	      for details. Default encodings.dir file is /usr/X11R6/lib/X11/fonts/encodings/encodings.dir

       -o, --output
	      Specify output, default is fonts.scale in the current directory

       -d, --font-dir
	      Specify TrueType font directory, default is the current directory

       -f, --default-foundry
	      Specify name of the default font foundry, default is "misc"

       -m, --max-missing
	      Specify the maximum number of missing characters per encoding, default is 5. This option applies to the encoding that has less  than
	      256 codepoint definitions.

       -a, --max-missing-percentage
	      Specify  the  maximum percentage of missing characters per encoding, default is 2. This option applies to the encoding that has more
	      than 256 codepoint definitions.

       -b, --font-backend
	      For X FreeType backend, use value "1", for XTT backend use value "2",  default  value  is  1.  When  you	have  TrueType	Collection
	      font(.ttc), you need to use this option.

       -x, --additional-entries
	      Additional  entries mean those extra TTCaps stuff for XTT backend, mainly for bold and italic font support. Or for FreeType backend,
	      because FreeType still doesn't support bold and italic font, ttmkfdir can generate extra "dummy" XLFDs, so applications  who  asking
	      those fonts won't complain.

	      Default value is "0" means off,otherwise use "1" to switch it on.

       -c, --completeness
	      use less strict completeness tests for encoding tables

       -p, --panose
	      use panose information

AUTHOR

       Yu Shao <yshao@redhat.com> and Pravin Satpute <psatpute@redhat.com>

LICENSE

       GNU Library General Public License

								  March 28, 2013						       TTMKFDIR(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Crontab job for exporting a Oracle database

Discussion started by: c.d.israel

2. Solaris

exporting a dmp file (oracle)from unix

Discussion started by: etravels

3. UNIX for Dummies Questions & Answers

finding out tables not used in scripts.

Discussion started by: Vasundhara

4. Shell Programming and Scripting

use shell scripts to update tables from databases

Discussion started by: wannabegeek