partitioning tables [message #372274] |
Wed, 24 January 2001 13:56 |
Chris
Messages: 128 Registered: November 1998
|
Senior Member |
|
|
will oracle7 allow me to partition tables. (or is it only oracle8 and oracle8i that support this command).
|
|
|
Re: partitioning tables [message #372303 is a reply to message #372274] |
Wed, 31 January 2001 20:37 |
Andrew again...
Messages: 270 Registered: July 2000
|
Senior Member |
|
|
You need to do in manually...
Create or replace view all_data as
(select * from data_2000
union all
select * from data_1999
union all
select * from data_1998)
Be sure to use the union all, not union as there is quite a big performance difference and different result set. Simply drop unwanted partition, create a new one and then recreate the view.
Of course your primary key values aren't maintained across the tables so you could have duplicates if you let them slip through your logic.
This is a tried and tested way of manually partitioning in 7.x
|
|
|