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@xxxxxxxxx> wrote: 
> 
> On 8/11/05, Bryan Wells <bunjibry@xxxxxxxxx> 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@xxxxxxxxx
Oracle DBA hopeful

Other related posts: