GLOBAL TEMPORARY TABLE CREATION ERRORS!

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.

TYPE:

Code:

---

create global temporary table employee_tmp on commit delete rows as select * from employee ;

---

create global temporary table employee_tmp
on commit delete rows
as select * from employee;

Use the query as given below

create global temporary table employee_tmp on commit delete rows as select * from employee

Hi!

Many thanks for the info!