Re: IMPort Utility sucks

From: Chas. Dye <ucdy_at_rvax.syntex.com>
Date: 19 Dec 1994 16:53:01 GMT
Message-ID: <3d4dpd$ai5_at_yoda.Syntex.Com>


In article <3cn4mv$28au_at_news-s01.ny.us.ibm.net>, gsalem_at_ibm.net writes:
|>I've using Oracle for several years now,
|>These last two days, I've been battling with the IMPort utility:
|>Is there any way to tell it not to use the "storage" clause that it has, and
|>use the default instead?
|>I'm trying to rebuild a test database out of a production one (a big one), and
|>I do not have all the space that it needs. So I keep getting the 1547 error message
|>
|>Any help would be very much welcomed
|>
|>#include <stddisc.h>
|>'Do you think you can tell,
|> heaven from hell' Pink Floyd.
|>
|>

Why don't you create the tables first - if you don't have scripts to do it then run the import but don't import the rows, then manually alter the storage parameters for the troublesome tables. After that, you can import the rows.

Regards,
Chas. Dye
Charles.Dye_at_syntex.com Received on Mon Dec 19 1994 - 17:53:01 CET

Original text of this message