SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add new column to Global Temporary table

AswathyJKJun 19 2013 — edited Jun 19 2013

HI,

CREATE GLOBAL TEMPORARY TABLE TEST

(

COL VARCHAR2(4 BYTE)

)

ON COMMIT PRESERVE ROWS

RESULT_CACHE (MODE DEFAULT)

NOCACHE;

this table is used in many procedures.Hence while i tried to add a column to this table.i got the below error

Error at line 2

ORA-14450: attempt to access a transactional temp table already in use

Could anyone please tell be how i can over come this?I'm using oracle 11g

Regards

Aswathy

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2013

Added on Jun 19 2013

4 comments

5,637 views