GLOBAL TEMPORARY TABLE CREATION ERRORS!

[amitstora]

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.

[julian]

TYPE:

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

[ales]

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

[sabita_ban]

Use the query as given below

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

[amitstora]

Hi!

Many thanks for the info!