Naeem wrote:
> But commit doesn't work. I ve checked already.
> Sybrand Bakker wrote:
>> On 21 Jun 2006 02:34:40 -0700, "Naeem" <naeemshzd_at_hotmail.com> wrote:
>>
>>> I have Oracle 9i DB R2 Enterprise Edition running on Windows 2000
>>> Server. When i create or update table using SQL plus, the changes could
>>> not be seen through Enterprise Manager. Similarly changes made through
>>> Enterprise Manager could not be seen through SQL plus. Please suggest...
>>
>> Two different sessions, result in 2 different transactions.
>> A commit is required to make the changes in session 1 visible to other
>> sessions.
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
- Do NOT top post
- You are incorrect: Commit does work!
I would suggest you enroll in a good class on database basics.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jun 22 2006 - 15:37:42 CDT