need help to create sql script
703145May 23 2009 — edited May 23 2009Hello,
I'm new to sql. I have one partitioned table called usage_events. I would like to create tables for number of entries in each partition on usage_events.
Manually imusing following sql :
Create table USAGE_EVENT_PB_20090519 tablespace USAGE_EVENTS_DATA as select * from usage_events partition(D20090519_USAGE_EVENTS) where service_class_id like '4%';
there are around 60 partitions and I want to create table for each partition. Can someone help me in creatin a sql script which i can run to create all the tables.
BR///
Abhimanyu