- You can edit the imp file and change the storage clause of your table.
- You can set commit=Y and buffer=1000 press ctrl-c after the first commit.
If you are fast enough you
will have only the 1st 1000 rows. (Its a little bit dirty)
"hongw1999" <hwangNOhwSPAM_at_channellcorp.com.invalid> schreef in bericht
news:203e8986.87328ac2_at_usw-ex0105-040.remarq.com...
> 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.
>
> 2. For a table with 50000 records, Is there a way to import only
> 1000 records?
>
> Thanks
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed May 10 2000 - 00:00:00 CDT
