OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Table [message #72338]

Mon, 19 May 2003 10:14

Raj
Messages: 411
Registered: November 1998

Senior Member

Hi,
i'm in process of exporting two tables and store in my unix box (For backup purpose).
But whenever i try to export , i get an error saying "no space in unix box".

Now i need to find out how much is the actual space needed for the backup of the two tables (Meg byte,G byte etc..)

How to find out the same ?

Thanks
Raj!!!!!!!

Report message to a moderator

Re: Export Table [message #72339 is a reply to message #72338]

Mon, 19 May 2003 11:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

in unix,
create a pipe.
'dd' read the pipe.
start exporting to the pipe.
depending on the blocksize you have set, you will see the display like,
Export terminated successfully without warnings.
5+0 records in , 5+0 records out etc,
intrepret it as 
the exported file size will be = your_block_size *   5

Report message to a moderator

Re: Export Table [message #72340 is a reply to message #72339]

Mon, 19 May 2003 11:28

Raj
Messages: 411
Registered: November 1998

Senior Member

Mahesh,

Is that possible to find the size of a table
in oracle ?

Say Table1 occupies 100 MB, is that mean if i export the table will have same size(100 MB) OR less OR more ?

URGENT Pls..

Raj!!!

Report message to a moderator

Previous Topic:	Incorrect Statistics Produced in SQLLDR version 8.1.6.0.0
Next Topic:	using password for internal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 20:18:11 CST 2024