Re: Question to export/import oracle8
From: Cristian Veronesi <c.veronesi_at_crpa.it>
Date: Thu, 02 Aug 2001 11:50:58 +0200
Message-ID: <3B692282.405B06AD_at_crpa.it>
Date: Thu, 02 Aug 2001 11:50:58 +0200
Message-ID: <3B692282.405B06AD_at_crpa.it>
Thomas Michel wrote:
> i have read in the manual the constraints are disabled during the impor
t.
Are you sure?
BTW, the best thing for me would be to use the IGNORE parameter to tell IMP to ignore errors due to table existance and to specify the correct table order using the TABLES parameter.
For example:
IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N Please check out the documentation for a complete parameter reference.
Best wishes, Cristian
-- Cristian Veronesi ><(((( > http://www.crpa.it "L'empirismo una serie di sbagli, e pi sbagli pi senti che stai crescendo, che vivi." (Luigi Meneghello)Received on Thu Aug 02 2001 - 11:50:58 CEST