Hello Ron <shameless plug> I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com <end shameless plug> I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10'
What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).