BCP out tool to export large table

#1

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

#2

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#4

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#5

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#6

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#7

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#8

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

Export for what purpose?

If to put in another Oracle database there is one answer ... if to put
into another company's product then name it.

It makes a difference.

PS: Why are you working on totally unpatched software?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#9

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

What is the prupose you need all data in human readable format?

Will EXP not do (especially with DIRECT=Y option)?

#10

news.free.fr wrote:

Quote:

Hello,
I am trying to find an oracle tool to export the content of a 20 million
records (on 22 col that contain number, varchar, float data type) much like
a bcp tool would do for sybase or sql.
So far I tried oracle sql developper which did not proved to be
fast/efficient.
Sqlldr only loads data into table.
sqlplus with a spool option is too slow for tables of that size.

Does anyone would know a simple oracle tool that could help me?
I am working under 10G environment on a windows XP client machine. Server is
10.2.0.1.

thanks

What is the prupose you need all data in human readable format?

Will EXP not do (especially with DIRECT=Y option)?