Re: Data missing in Personal Oracle 8i

Your description switched from (total 16) machines to (3 or 4?) groups - this confuses me.
* So the DML statements on 2 machines were committed * Most of the "groups" found their data missing later - if "group" is interchangeable with "machine", then I would expect that up to 14 could find there data missing, depending on how they exited the database "tool" in which the DML statements were issued. My assumption is that SQL*PLUS was used as the SQL command processor. * A couple of things to keep in mind about SQL:

• Data Definition Language (DDL) statements (creating, deleting, altering database objects such as tables, constraints, columns, sequences) commmit IMPLICITLY
• DML statements (insert,update,delete,etc.) required an explicit COMMIT statement
• The "normal" exit of SQL*PLUS implicitly commits any pending transactions
• An "abnormal" exit of a tool like SQL*PLUS (GPF, power failure, reboot, etc.) usually results in a rollback of pending transactions (e.g. they are not committed and are thus lost). I find it hard to believe that 14 "machines" were rebooted or GPF'd, although a power outage affecting all is possible.
  • Don't have enough information to tell you for sure. Hope this helped some.

Cliff

Martin Gutowski wrote:
>
> Hi,
>
> I'm a newbie dba administering Personal Oracle 8i installed on
> Windows 2000 machines in a classroom setting. Last week we had
> the class creating their own tables and populating them with
> their own data. We checked at each machine to see that they
> had created the tables and could query them. In only a few
> cases (2 of 16 machines) did I have the group 'commit.' A week
> later, they came back and most of the groups found their data
> missing. Of the 3 or 4 groups that still
> had their data, only one or two had 'commit'ed. I'm wondering
> what happened to the data. I should say that all the tables they
> had created were still present; they just had no rows.
>
> Marty
Received on Wed Nov 29 2000 - 06:31:35 CET