Re: exp/imp questions

In article <203e8986.87328ac2_at_usw-ex0105-040.remarq.com>,   hongw1999 <hwangNOhwSPAM_at_channellcorp.com.invalid> wrote:
> I am using imp to import data that our customer export from there
> database. It is user level exp/imp.
>
> I have two questions:
>
> 1. I want import table structure only (rows=N), but there is a
> table with initial=60M, I don't have enough space on tablespce,
> is that posible to solve this problem w/o increasing tablespace.
>

I do not think so. You should just manually allocate it. If you were importing data you could pre-allocate it and then use the ignore=y option on the import to load the data.

> 2. For a table with 50000 records, Is there a way to import only
> 1000 records?
>

No, an import is either all the data that was exported or none of the data for a particular table.

> Thanks
>

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


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