Bugs on temporary table

[Mr. Liu]

To create indexes on temporary table, PL/SQL Developer will apply the statement like this:

-- Create/Recreate indexes
create index RISKDATA.idx1 on RISKDATA.T_NOR_STOCKACCOUNT(stock_account);

However, if you export this temporary table, you may see the statement like this:

-- Create table
create global temporary table RISKDATA.T_NOR_STOCKACCOUNT
(
stock_account INTEGER not null
)
on commit delete rows;
-- Create/Recreate indexes
create index RISKDATA.IDX1 on RISKDATA.LQW (STOCK_ACCOUNT)
nologging;

which leads to error ORA-14451: unsupported feature with temporary table, resulting from the nologging keyword.

Please check this issue. See the attachment to find the version info related to this bug.

 

[Marco Kalter]

We'll fix it.