Re: import with direct=y

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Fri, 05 Mar 1999 17:33:19 +0800
Message-ID: <36DFA4DF.A05@bhp.com.au>

Monique van Daal wrote:
>
> Does anybody know if it is possible to do an import with direct = Y
> (Oracle 7.3.3)

Nope - but some ways of speeding up import are:

When Unloading:

exp file1 rows=y constraints=n grants=n direct=true compress=n exp file1 rows=n

When reloading:

imp file1 - just data goes in
grep file2 to grep out the following sql's

1. alter add primary key - add unrecoverable, parallel and ";"
2. alter add unique - add unrecoverable, parallel and ";"
3. alter add foreign key - add ";"
4. alter add check - add ";" imp file2 indexfile=idx.sql
5. add unrecoverable, parallel and ";" to idx.sql

and run the five files thru sql plus...

I think thats about as good as you can get in terms of exploiting the "speed up" features

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Fri Mar 05 1999 - 03:33:19 CST