Re: Import Help

First of all, thank you all for your comments and assistance. I can only hope that one day i have been pulled through the mud enough to learn something and share on this or other forums.  here is the batch contents that calls the below listed attributes:  imp 'system/######@gdwstgt as sysdba' parfile=imp_consol_part_table.txt  After seeing Mladen's reply, I double checked the table structures. After all, Im DBA in training. I did need to add that attribute to the table, however, this is one of many, many errors of the same nature, where the table attributes exist. I even recreated INVOICE_ITEM in the test instance with the ddl from the production instance, less the partitioning of course. Still the same error.
 grazie...
B
 On 8/12/05, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> 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
>

-- 
Bryan Wells
bunjibry_at_gmail.com
Oracle DBA hopeful

--
http://www.freelists.org/webpage/oracle-l