-
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
Sabitabrata
-
Many Thanks!
Hi!
Many thanks for the info!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|