Re: import in 8i and constraints

"zeb" <thierry.constant1_at_free.fr> wrote in message news:3d3dadd9$0$462$626a54ce_at_news.free.fr...
> Hi,
>
> I did a full export from a database 7.3.4 (AIX)
> and I did a full import to a new database 8.1.7 (WNT 4)
>
> 2 questions:
>
> - I have to run catexp7 before doing the import ???
>
> - when I import to the 8.1.7 , I got a lot of :
> ORA-02261 such unique or primary key already exists in the table
> and I loosed my PK
> Why I have this, what the good way to do a full import ????
>
> Thanks in advance
>
>

I have seen this before. You should be able to add the PK very quickly with an ALTER TABLE command. Make sure the name the PK constraint the same as the unique index and make sure the columns are the same and in the same order as the index.

I would also suggest ...

1. Double checking that all objects that were valid in the source databases are valid in the destination.
2. Making sure that all grants were copied over. Especially if you have granted privileges on SYS objects to non system users.
3. Make sure all objects came over.

You should be able to create a database link and run some rather simple queries to do all this. Received on Tue Jul 23 2002 - 15:39:54 CDT