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/######@(protected) 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@(protected)> wrote: > > On 8/11/05, Bryan Wells <bunjibry@(protected)> 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 >
<div>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.</div> <div> </div> <div>here is the batch contents that calls the below listed attributes:</div> <div> </div> <div>imp <a href="mailto:'system/######@(protected)">'system/######@(protected)</a> as sysdba' parfile=imp_consol_part_table.txt</div> <div> </div> <div>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. </div> <div> </div> <div>grazie...</div> <div>B<br> </div> <div><span class="gmail_quote">On 8/12/05, <b class="gmail_sendername">Niall Litchfield</b> <<a href="mailto:niall.litchfield@(protected)">niall.litchfield @(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">On 8/11/05, Bryan Wells <<a href="mailto :bunjibry@(protected)">bunjibry@(protected)</a>> wrote:<br>> Can some one see what I am missing/doing wrong? I am attempting to import <br>> data from a parfile to get data from a partitioned table to non -partitioned<br>> table and am getting the following error. i have truncated the tables and<br>> set ignore=y. is that not enough? <br><br>I'm with mladen here - I don't see why you are getting a DBMS_STATS <br>error if not choosing to import stats.<br><br>that said is the table definition the same in your target as it was in<br>the source? i.e does dw_sold _to_customer_id exist in the invoice table<br>for your target db?<br> <br>--<br>Niall Litchfield<br>Oracle DBA<br><a href="http://www.niall .litchfield.dial.pipex.com">http://www.niall.litchfield.dial.pipex.com</a><br>< /blockquote></div><br><br clear="all"><br>-- <br>Bryan Wells<br><a href="mailto :bunjibry@(protected)"> bunjibry@(protected)</a><br>Oracle DBA hopeful
