export table from oracle database

inquirer · #1 (**permalink**) 06-24-2003

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.

thanks as usuall

thehoghunter · #2 (**permalink**) 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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Install Guide: Oracle Database 11g Release 1 on Oracle Enterprise Linux 5	iBot	Oracle Updates (RSS)	0	04-06-2008 05:10 AM
Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11g ADF Busin	iBot	Oracle Updates (RSS)	0	04-06-2008 05:10 AM
Export a HTML table to Xcel	garric	Shell Programming and Scripting	3	02-01-2008 05:46 AM
help for writing shell script to export table data	sankarg	Shell Programming and Scripting	3	10-18-2006 06:01 AM
unix script to export data from csv file to oracle database	vinayagan	Shell Programming and Scripting	3	07-20-2005 04:16 AM

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


	Powered by