Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Weird IMP behaviour in 9iR2

Re: Weird IMP behaviour in 9iR2

From: Tarby777 <nick_williamson_at_mentorg.com>
Date: Fri, 27 Jul 2007 13:37:53 -0000
Message-ID: <1185543473.503565.122730@d55g2000hsg.googlegroups.com>


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. Received on Fri Jul 27 2007 - 08:37:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US