help for writing shell script to export table data - Shell Programming and Scripting

sankarg · #1 07-31-2006

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,

Hitori · #2 07-31-2006

This topic has been discussed a lot, try to search first by 'oracle', 'sql' keywords

sankarg · #3 07-31-2006

Can any one provide the link / guidelines. that's enough

Thanks

ankitgupta · #4 10-18-2006

here is the script'

connect to db;
export to 'path of the file' of del select * form table

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
script or piece of code where the data returned by a stored procedure you are writing	enigma_83	Shell Programming and Scripting	3	04-25-2008 03:44 AM
help for a perl script - writing to a data file	meghana	Shell Programming and Scripting	2	02-04-2008 02:05 PM
Export a HTML table to Xcel	garric	Shell Programming and Scripting	3	02-01-2008 02:46 AM
unix script to export data from csv file to oracle database	vinayagan	Shell Programming and Scripting	3	07-20-2005 01:16 AM
export table from oracle database	inquirer	Shell Programming and Scripting	1	06-24-2003 06:48 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode