Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn
fitzjarrell_at_cox.net wrote:
> On Sep 28, 2:13 am, "Alexander Peters" <apet..._at_ap-data.de> wrote:
> > Hello!
> > I've got a Problem with COMMENT ON TABLE and COMMENT ON COLUMN. I
> > exported and imported a User scheme and now i have
> > some comments on the wrong column. It seems, that this Problem
> > happens only on tables where columns from datatype
> > long varchar and long binary. Is there a way to protect my comments
> > for this issue?
> >
> > Example of my Problem:
> >
> > Comments bevor Exp/Imp
> > TableA.ColumnA CommentA
> > TableA.ColumnB CommentB
> > TableA.ColumnC CommentC
> > TableA.ColumnD CommentD
> >
> > After reimport with Imp
> > TableA.ColumnA CommentA
> > TableA.ColumnB CommentC
> > TableA.ColumnC CommentB
> > TableA.ColumnD CommentD
> >
> > I use Oracle 9.2 Ent. on Windows
> >
> > regards
> > A. Peters
>
> 9.2 doesn't tell us much; post all four numbers of the release so we
> know which patch level (if any) you are on.
>
> How was this export file created? Please post the full exp command
> you (or someone else) used to generate this .dmp file.
>
> Have you done this:
>
> imp user/pass file=... full=y show=y log=<some logfile name here>
>
> to discover what, exactly, imp is doing?
>
> You have provided very little usable information to base a definitive
> (or semi-definitive) answer upon. Please provide the requested items
> so someone might have enough data to formulate an answer.
>
>
> David Fitzjarrell
Hello!
I have an Oracle 9.2.0.1 Server.
I imported with "imp testuser/testpass file=.... fromuser=Newdbdesign touser=testuser log=import.log"
--Received on Fri Sep 28 2007 - 16:10:21 CDT