Home » RDBMS Server » Server Utilities » export time (9i windows)
export time [message #324637] Tue, 03 June 2008 07:35 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi people,
I just wanted to know the time it will take to export a table of a million rows approximately..

Thanks,
Arun
Re: export time [message #324641 is a reply to message #324637] Tue, 03 June 2008 07:57 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Too many factors at play here. Do the export and you'll have your answer.
Re: export time [message #324644 is a reply to message #324637] Tue, 03 June 2008 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL> create table test as select level num from dual connect by level <= 1000000;

Table created.

SQL> select sysdate from dual;
SYSDATE
-------------------
03/06/2008 15:20:52

1 row selected.

SQL> host exp michel/michel file=t.dmp buffer=10000000 tables=test

Export: Release 10.2.0.4.0 - Production on Tue Jun 3 15:21:18 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                           TEST    1000000 rows exported
Export terminated successfully without warnings.

SQL> select sysdate from dual;
SYSDATE
-------------------
03/06/2008 15:21:44

1 row selected.

About 48 second on my workstation including the time to type the commands.

Regards
Michel
Re: export time [message #324814 is a reply to message #324644] Wed, 04 June 2008 03:42 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
So much thanks Michel & Joy for the answers..
Previous Topic: Export Buffer size
Next Topic: sql*loader
Goto Forum:
  


Current Time: Tue Dec 24 10:28:34 CST 2024