Re: merging 2 tablespaces -> oracle 8.1.7

"M. Beine" <m.beine_at_gmx.net> wrote:

>can i and how can i merge 2 tablesspaces?
>both spaces containing the same type of tables, just the number of rows
>in each table differs. so i want to append table1 of tablespace1 to
>table1 of space 2!
>Thanks
>Mike

Ok, first things first - a tablespace in not a real thing..It is Oracle's way to refer to a collection of 1 or more data files used by Oracle to store stuff..

Tables exist in Tablespaces ( but so does other stuff, like Indexes ). To append the contents of one table to another ( assuming exactly the same structure) just do

insert into table2 select * from table1;

After that completes, you can drop table1.

Do that for each matching table in the first tablespace and, if that is ALL the tablespace contains, you can drop it after all the appends have been done.

hth, Received on Fri Aug 15 2003 - 11:05:22 CDT