Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Commit for a single table?
Hi!
is there any way of performing a COMMIT on a single table only (i.e. w/o also commiting changes to the rest of the tables)?
or is it possible to maybe have two (or more) independent table-spaces (or simmilar) in a database so that a connection to a specific db-space only commits all tables in this table-space - leaving all others untouched?
i need this to code some sort of DB-based IPC (a message queue implemented in a table; whenever adding a message (=row) this row must be visible to all connections/sessions - i.e. i do have to perform a commit after inserting the row... but for the sake of tranactions i don't want to many commits...
any suggestions????
Thanks,
Hannes
Received on Thu Apr 15 1999 - 13:57:23 CDT