Re: Append two tables into one

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Thu, 15 Mar 2001 10:28:53 +0300
Message-ID: <98pqjn$d95$1@news247.cnt.ru>

Hello!

If you use Oracle 8.x or later, you may take benefit by using partitioning option.
Firstly, create partition table.
After that use command ''alter table <partition_table> exchange partition <name_partition> with table <yor_first_table>''. And repeat for second table.
This method works instantly!!!!! (no redo logs etc.). Also it very ueful if you ,for example, whant to join to tables with same data for different months etc.

Best regards.
Yaroslav.

"Doug" <dmccurdy_at_gwrmail.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:w0Qr6.14123$R_6.1458019_at_newsread2.prod.itd.earthlink.net...
> What is the best way to append two tables into one table? There are about
> 140000 rows to import.
>
> Thank you
>
>
Received on Thu Mar 15 2001 - 01:28:53 CST