Re: CREATE SEQUENCE commits transaction

From: Gert Brinkmann <gbrinkmann_at_dimedis.de>
Date: Thu, 07 Mar 2002 10:54:01 +0100
Message-ID: <3C8738B9.75140255@dimedis.de>

Thomas Kyte wrote:

> No, temp tables SHOULD NOT be created in a transaction. They too should be
> created at application installation time. They are persistant objects in the
> data dictionary (so you can reference them in PLSQL when its compiled for
> example -- they always exist) but hold transient data.
[...]

Thank you for this very detailed answer. (I have got to know temp-tables from informix first and did not need them in oracle so far)

Gert Received on Thu Mar 07 2002 - 03:54:01 CST