Michael,


Michael Vilhelmsen schrieb:

> I just took hold of the backup file this morning to do some research
> in the data locally.
>
> I can ONLY restore the DB if I do NOT active any index !

Is there any message which foreihn key constraint is causing the error?
(ie sth. like INTEG_42)

If so, have a look in the system tables to find out which tables are
involved; then try a select on the involved tables to find out if there
are "abandoned" detail records. If so, delete them, do a backup and
restore again.

> Then afterwards I can active any index' NOT involving foreign keys.
>
> I can DELETE any foreign key already defined.
>
> But what I can't do is:
>
> - Active ANY foreign key reference !
> - Make ANY new foreign keys !

What's the error message you get?

>
>
> Right now, there is no problems, since the original DB is up and
> running.
>
> But if I don't find this error, I think I will get into trouble in
> the future.......

Hmm, if everything fails you can still do a datapump.

Luc.