Question: how to copy data from one table to another in netezza?
Answer: One way you could move the data is by using Transient External Tables . Start by creating a flat file from your source table/db. Because you are moving from Netezza to Netezza you can save time and space by turning on compression and using internal formatting. CREATE EXTERNAL TABLE 'C:\FileName.