Sponsored Content
Top Forums Shell Programming and Scripting export table from oracle database Post 37629 by thehoghunter on Tuesday 24th of June 2003 09:48:42 AM
Old 06-24-2003
First, I'm not a Oracle expert (or even a DBA). But in working with them I've learned some things and I know when they do their exports (of an entire database) they need approximately the same space as the database is USING, not what it's set up to (as far as growth).

The same for exporting tables - if it's set up to be 200mb but is only using 25mb, then you would need 25 mb free to export it. Always add 5-10% to be sure and I also believe they compress it on the way out.

See the following info on determining the size of a table:
samoratech.com - table size
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

2. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

3. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

4. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

5. Shell Programming and Scripting

Script to count the dataflow in a table in oracle database

I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table number of rows which are getting filled per hour on current day and the peak hour of the current day number of rows which are... (5 Replies)
Discussion started by: PhAnT0M
5 Replies

6. UNIX and Linux Applications

Help in copying table structure to another table with constraints in Oracle

hi, i need to copy one table with data into another table, right now am using create table table1 as select * from table2 i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies

7. Shell Programming and Scripting

Export table and restart from last table

Hello all, Thank you in advance for reading my post and helping me.. Scenario: I have 50 tables whose names are in a file export.sql, i use the below command to export all these tables one by one cat export.sql|while read tn do echo "export to $tn.del of del select from... (7 Replies)
Discussion started by: family_guy
7 Replies

8. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
TREELINE(1)															       TREELINE(1)

NAME
treeline - an information storage program SYNOPSIS
treeline [qt-options--][infile] treeline [import-option][export-option][misc-options]infile[infile2...] DESCRIPTION
Do you have lots of sticky notes lying around with various useful information jotted down? Or many lists of books, movies, links, website logins, personal contacts, or things to do? Can you find them when you need them? Well, I often couldn't. So here's my answer. Some would call TreeLine an Outliner, others would call it a PIM. Basically, it just stores almost any kind of information. A tree struc- ture makes it easy to keep things organized. And each node in the tree can contain several fields, forming a mini-database. The output for- mat for each node can be defined, and the output can be shown on the screen, printed, or exported to HTML. TreeLine is used to organize and store text data in a tree structure. It is well suited to keeping track of many different types of infor- mation. Each node of the tree can contain several defined fields, forming a mini-database. The format of each node can be defined, and the output can be shown on the screen, printed, or exported to HTML. The tree structure is navigated and edited in the left pane of the window, while various views of the child data are shown and editable in the right pane. The data is stored in XML text files. OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. For a complete description, see the Info files. Qt-options: see Qt documentation for valid Qt options Import-options: --import-tabbed import a tab indented text file --import-table import a tab-delimitted text table, one node per line --import-lines import plain text, one node per line --import-para import plain text, one node per paragraph --import-treepad import a Treepad text-node file --import-xbel import an XML bookmark file in XBEL format --import-mozilla import an html bookmark file in Mozilla format --import-xml import a generic XML file (non-TreeLine format) Export-options: --export-html export a single HTML file --export-dir export HTML in directories --export-xslt export an XSLT file --export-tabbed export a tab indented text file --export-table export a text table of the first children only --export-xbel export an XML bookmark file in XBEL format --export-mozilla export an html bookmark file in Mozilla format --export-xml export a generic XML file (non-TreeLine format) Misc-options: -o, --outfile=FILE output filename, not used with multiple infiles -n, --no-root exclude the root node form the output if applicable --add-header add a header and footer to HTML exports --indent=NUM change the indent amount for HTML exports (default=20) -q, --quiet supress normal status information, only give errors -h, --help display this information and exit No more than one import-option and one export-option may be specified. If either are not present, the native TreeLine file format is assumed. The output filename option can only be specified if there is only one input file. If it is not specified, the input's base file name is used with the appropriate output file extension. If the extensions are the same, an underscore is added before the extension. Note that this avoids overwriting the input file, but other files may be overwritten without notification if they share the output file's name. SEE ALSO
You can find more extensive help about treeline in /usr/share/doc/treeline/README.html AUTHOR
treeline was written by Doug Bell <doug101@bellz.org>. This manual page was written by Miriam Ruiz <little_miry@yahoo.es>, for the Debian project (but may be used by others). enero 3, 2006 TREELINE(1)
All times are GMT -4. The time now is 05:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy