"create table as select * from" doesnt work...
440807Mar 23 2005 — edited Mar 23 2005Hi,
I have a weird problem.. I am creating a table from the inner join of two very large tables (about 40million records each). Select * from the inner join works perfectly but when I try to "create table xx as select * from inner join" the applications (toad, sqlplus hangs forever). I really dont understand if there is a problem with the join but in such case even the select statement shouldnt work but I am not sure ..
PS: The tables are indexed
Any help would be greatly appreciated,
Qwerty