SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 07:43 AM
| ||||
| ||||
 Problem with COMMENT ON ... comments after reimport on the wrong colulmn 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      |
|
02-26-2008, 07:43 AM
| |||
| |||
| Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn Alexander Peters wrote: > 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/ |
|
02-26-2008, 07:43 AM
| |||
| |||
| Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn On Sep 28, 2:13 am, "Alexander Peters" <apet...@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 |
|
02-26-2008, 07:43 AM
| |||
| |||
| Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn On Sep 28, 12:13 am, "Alexander Peters" <apet...@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 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 |
|
02-26-2008, 07:43 AM
| ||||
| ||||
| Re: Problem with COMMENT ON ... comments after reimport on the wrong colulmn fitzjarrell@cox.net wrote: > On Sep 28, 2:13 am, "Alexander Peters" <apet...@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" -- |
 |
« want to see code of stored procedure but without permission to execute it
|
"best" option to abort a running stored proc »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:25 PM.
