Problem with COMMENT ON ... comments after reimport on the wrong colulmn

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alexander Peters - 28 Sep 2007 08:13 GMT

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

Reply to this Message

Jerome Vitalis - 28 Sep 2007 09:01 GMT

> I use Oracle 9.2 Ent. on Windows

See bug 4711857 on Metalink.
-----
échangez opinions et commentaires dans les forums de discussion.
http://www.usenetgratuit.com/

Reply to this Message

Alexander Peters - 28 Sep 2007 09:32 GMT

> > I use Oracle 9.2 Ent. on Windows
>
> See bug 4711857 on Metalink.

Thanks for Help

Regards
A. Peters

--

Reply to this Message

fitzjarrell@cox.net - 28 Sep 2007 17:25 GMT

> Hello!
> I've got a Problem with COMMENT ON TABLE and COMMENT ON COLUMN. I
[quoted text clipped - 22 lines]
> 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

Reply to this Message

Alex Peters - 28 Sep 2007 22:10 GMT

> > Hello!
> > I've got a Problem with COMMENT ON TABLE and COMMENT ON COLUMN. I
[quoted text clipped - 40 lines]
>
> 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"

--

Reply to this Message

joel garry - 28 Sep 2007 18:13 GMT

> Hello!
> I've got a Problem with COMMENT ON TABLE and COMMENT ON COLUMN. I
[quoted text clipped - 22 lines]
> regards
> A. Peters

Bug 4711857, see Note:4711857.8

metalink is your friend!

jg
--
@home.com is bogus.
Pop Quiz: This headline is from where? "Easy ways to fly locked and
loaded"
A. Guns&Ammo
B. NRA magazine
C. Hints From Heloise
D. American Drunkard magazine
E. Homeland Security Today

Reply to this Message