Home » SQL & PL/SQL » SQL & PL/SQL » Want to copy/append data in one table to another
Want to copy/append data in one table to another [message #214912] Thu, 18 January 2007 09:42 Go to next message
sharath160
Messages: 9
Registered: August 2006
Junior Member
Hi,

I have two similar tables Alo_table and Alo_table_test with different indexes, partitions etc.

Alo_table has some data. I want to copy/append this data in to Alo_table_test for further testing. How to copy/append data without changing the other settings from Alo_table to Alo_table_test?

Thanks in advance,
Sh
Re: Want to copy/append data in one table to another [message #214915 is a reply to message #214912] Thu, 18 January 2007 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
INSERT INTO Alo_table_test select * from Alo_table;
Re: Want to copy/append data in one table to another [message #214916 is a reply to message #214915] Thu, 18 January 2007 09:53 Go to previous messageGo to next message
sharath160
Messages: 9
Registered: August 2006
Junior Member
Thnks buddy!
Re: Want to copy/append data in one table to another [message #214917 is a reply to message #214916] Thu, 18 January 2007 10:01 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Depending upon what you truly mean by "append", then you may also want to utilize (if your situation allows it) the APPEND hint with anacedent's suggestion.
Previous Topic: How to create Primary Key
Next Topic: ROW_NUMBER() function help
Goto Forum:
  


Current Time: Sun Dec 04 20:46:13 CST 2016

Total time taken to generate the page: 0.07617 seconds