Re: imp full=y

From: <RogBaker_at_gmail.com>
Date: 7 Dec 2005 12:33:53 -0800
Message-ID: <1133987633.240144.192950@z14g2000cwz.googlegroups.com>

It's a db upgrade. I am going to use the Upgrade Assitant/Wizard to tell me what changes I need to make to my init file etc for the newer version of Oracle, but first I want to test it on a copy of the database. That's why I am doing imp/exp to a new machine/os. I did not want to just export the schema because it is actually several schemas for several applications. I did not want to have to re-create the users/permissions etc, so I figured a full import would take care of everything in one fell swoop. Yes, a full export was done as SYSTEM.

In the log, I see stuff like:
"VDK_TMP_SQLTABLE_29015" 3 rows imported

I assume that's fine since it appears to be a temp table. Other junk which does not alarm me:

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (AURORA$JIS$UTILITY$.SYS_C001012) violated

And it looks like constraints prevented the system tables from getting all screwed up:

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.HELP_TOPIC_SEQ) violated

Column 1 COLUMN
Column 2 17
Column 3 ALI[AS] alias Received on Wed Dec 07 2005 - 14:33:53 CST