create table xxx as select <something> from <old_table> On 11/21/05, Dominik Smatana <dominik@xxxxxxxx> wrote: > > Hello, > is there any way in Oracle to dynamically create a new temporary table > direct from select? >