RE: Data Extract

[Orlando Andico]

On Fri, 8 Jun 2001, Marcotullio, Angelo   wrote:
..
> Oracle export (exp) creates a binary file that can only be loaded using the
> import (imp) program.  The problem with import is that it uses insert
> statements to load the data.

There's a way to bypass rollback- and index creation during the import,
which speeds things up a lot. I believe this is the same technique used by
the SQL*Loader "direct path" option.


-- 
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------