RE: Import Help

Bryan,  

As I said in my previous post, I am thinking that the system user is not able to import statistics for the table to the CONSOL user. Try importing using the CONSOL user. You may need to grant the IMP_FULL_DATABASE role to the CONSOL user for this to work.  

Tom  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bryan Wells Sent: Friday, August 12, 2005 9:39 AM
To: Niall Litchfield
Cc: Oracle-L
Subject: 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