Re: Can't commit changes to table

From: <eswar_oracle_at_hotmail.com>
Date: Fri, 19 Feb 1999 10:15:17 GMT
Message-ID: <7ajdjg$8f5$1@nnrp1.dejanews.com>

Hi John

Try manually at Sql plus. Is there any data in the table. If you want to know whether it is modified or not spool the script to a file. I do not think you have to explictly commit because when you are issuing Alter table itself commits the changes.

What you can do

Step 1. Add at the begining of your Script Spool c:\temp.txt

Step 2. Add at the end of your script Spool off

So that you can monitor what's happening by viewing temp.txt file

Regards
Eswar

In article <7aitv6$r65$1_at_nnrp1.dejanews.com>, jvnet_at_excite.com wrote:
> I ran a SQL script to change a column in a table from CHAR(6) to CHAR(*). I
> run a "desc" after and no changes have taken place. I'm assuming a rollback
> occurred even though I appended "commit" to the end of the script. What would
> cause a commit to not occur in this type of situation ?
>
> Thanks
> John
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 19 1999 - 04:15:17 CST