Re: Weird IMP behaviour in 9iR2

On Jul 27, 8:37 am, Tarby777 <nick_william..._at_mentorg.com> wrote:
> On 27 Jul, 13:06, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > Do this:
>
> > imp file=their_file.dmp fromuser=their_user touser=my_user
> > indexfile=my_log_list.txt
>
> > You need to find out what Oracle is trying to do when it creates this
> > table, and the above command should show you that.
>
> > You may find your answer in the output.
>
> OK thanks, done that. Regarding the problem table, I see the
> definition of the table itself in the index file, but not its primary
> key or uniqueness constraints; they're just not there.

Interesting, as you report that other constraint definitions exist, else I would expect that constraints=n was given as an exp parameter.

This is confusing, I must admit. Is there any information from Metalink on this?

David Fitzjarrell Received on Fri Jul 27 2007 - 11:25:54 CDT