Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Append data from one table to another.

JaffyNov 30 2007 — edited Nov 30 2007

Hi,

I want to insert/append some or all the data from one table to another table.

For eg: Data from table table1 to be appended to table2 with the same constraints, indexes etc. The columns are same for both the tables.

I am using 10g version 2.

Please specify which method would be good for this process.

Thanks

Jafar

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2007

Added on Nov 30 2007

#general-database-discussions

4 comments

541 views