ORA-14451 unsupported feature with temporary table Cause An attempt was made to create an IOT, specify physical attributes, specify partition or parallel clause. Action do not do that.Was this page helpful? © Oracle About Oracle Contact Us Products A-Z Terms of Use & Privacy Cookie 喜好...
CREATE PRIVATE TEMPORARY TABLE ORA$PTT_sales_ptt_transaction * ERROR at line 1:ORA-14451: ...
select username,default_tablespace,temporary_tablespace from user_users;用alter user 改变用户的默认表空间和临时表空间.举例:alter user system default tablespace usertemporary tablespace temp;
SQL> CREATE PRIVATE TEMPORARY TABLE ora$ptt_my_temp_table ( id NUMBER, description VARCHAR2(20) ) ON COMMIT DROP DEFINITION; 2 3 4 5 CREATE PRIVATE TEMPORARY TABLE ora$ptt_my_temp_table ( * ERROR at line 1: ORA-14451: unsupported feature with temporary table 1. 2. 3. 4. 5. 6. ...
select username,default_tablespace,temporary_tablespace from user_users;用alter user 改变用户的默认表空间和临时表空间.举例:alter user system default tablespace usertemporary tablespace temp;