Re: Oracle Import Question

From: <michael_bialik_at_my-deja.com>
Date: Wed, 10 Nov 1999 21:59:34 GMT
Message-ID: <80cps3$i1i$1@nnrp1.deja.com>

In article <80cggm$adv$1_at_nnrp1.deja.com>, daren_davis_at_my-deja.com wrote:
> Actually, two questions.
>
> When performing a full import ( from a full
> export file ), is it possible to:
>
> a) import only the table structures, and not the
> data.

Yes. Just use parameter ROWS=N

> b) explicitly reject certain tables from being
> imported. ( Reject some huge archive tables to
> speed up the import ).
>

Yes, but you cann't EXCLUDE tables, you must INCLUDE all table you would like to import, unless all these archive tables belong to single schema.
Use parameter TABLES=list of tables

> Thanks, in advance.
>
> Daren Davis

Welcome. Michael.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 15:59:34 CST