Hi all!

Working on Oracle v8i with OS as NT!

I have this problem while creating Temporary Tables as under:


1.SQL> create global temporary table employee_tmp as
2 select * from employee on commit delete rows;
select * from employee on commit delete rows
*
ERROR at line 2:
ORA-00933: SQL command not properly ended


2.SQL> create global temporary table employee_tmp as
2 select * from employee on commit preserve rows;
select * from employee on commit preserve rows
*
ERROR at line 2:
ORA-00933: SQL command not properly ended


SQL>

Why is the above command not accepted successfully!

Could you please focus upon the area as to where I had gone wrong!

Thanks & Regards,

Amit.