Temporary Tables
Temporary tables are useful to developers who wants to stage some temporary data, but there're restrictions on them. Let's see an example.
SQL> alter table "ERPAPP"."PAY_SEG_BILL_TMP" logging;
alter table "ERPAPP"."PAY_SEG_BILL_TMP" logging
*
ERROR at line 1:
ORA-14451: unsupported feature with temporary table
ORA-14451
It turns out that we can't enable logging attribute on a temporary table and failed with ORA-14451. In fact, we cannot specify the following clauses on a temporary table:
- LOB_storage_clause
- storage_clause
- logging_clause
There're more restrictions on using temporary tables. If you need those features above to be supported on your table, please use a normal table.
By some reason, I get error about this without specifying.
Hence I suspect the database is configured with it.
Therefor it would be smart if you told how to turn these things off.
An attempt was made to create an IOT, specify physical attributes, specify partition or parallel clause.
Thanks for sharing.