Re: Import Help
Import Help -- Bryan Wells 2005-08-11
Import Help -- Niall Litchfield 2005-08-12
Import Help -- Bryan Wells 2005-08-12
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:
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.
On 8/12/05, Niall Litchfield <firstname.lastname@example.org> wrote:
On 8/11/05, Bryan Wells <email@example.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?
Oracle DBA hopeful