Re: Import Help

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 12 Aug 2005 12:53:18 +0100
Message-ID: <7765c897050812045313fa32ea@mail.gmail.com>

On 8/11/05, Bryan Wells <bunjibry_at_gmail.com> wrote:
> Can some one see what I am missing/doing wrong? I am attempting to import
> data from a parfile to get data from a partitioned table to non-partitioned
> table and am getting the following error. i have truncated the tables and
> set ignore=y. is that not enough?

I'm with mladen here - I don't see why you are getting a DBMS_STATS error if not choosing to import stats.

that said is the table definition the same in your target as it was in the source? i.e does dw_sold_to_customer_id exist in the invoice table for your target db?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 12 2005 - 06:55:20 CDT