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

On Sep 28, 2:13 am, "Alexander Peters" <apet...@xxxxxxxxxx> 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

.

Relevant Pages

  • Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn
    ... exported and imported a User scheme and now i have ... After reimport with Imp ... you used to generate this .dmp file. ... I have an Oracle 9.2.0.1 Server. ...
    (comp.databases.oracle.server)
  • imp.exe crash on windows xp (Oracle ver. 9.2.0.8)
    ... running on windows XP Pro (a developer ... The size of my dmp file is avout 1,7 Gb. ... This import contains table with blob data type. ... I use the following imp command to import the schema: ...
    (comp.databases.oracle.server)
  • Re: imp only user accounts
    ... >I have a dmp file created with exp on 8i. ... >I would like to imp the user accounts, ...
    (comp.databases.oracle.misc)
  • imp only user accounts
    ... I have a dmp file created with exp on 8i. ... I would like to imp the user accounts, including their passwords and ...
    (comp.databases.oracle.misc)