Home » SQL & PL/SQL » SQL & PL/SQL » Create partitioned table as select (Oracle 10g R2, RHEL4)
Create partitioned table as select [message #299470] Tue, 12 February 2008 02:58 Go to next message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Hi,

I am writing a script which creates the transportable tablespace by monthly data from the huge data table. It's partitioned daily. I need to create same structured, indexed but month range partitioned table.
How can I create it?

For example:
Huge table is T1001, my create table is T1001_200708.

T1001_200708 table should contain partitions from P20070801 to P20070901.
Re: Create partitioned table as select [message #299577 is a reply to message #299470] Tue, 12 February 2008 08:09 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Why don't you create a regular table and EXCHANGE partitions?

Michael
Previous Topic: i was unable to create a materialized view on this view (merged)
Next Topic: FILE CONVERSION
Goto Forum:
  


Current Time: Wed Dec 07 12:40:26 CST 2016

Total time taken to generate the page: 0.32399 seconds