Skip to Content
0
Jan 20, 2020 at 12:11 PM

Copy Data from one table to another table in HANA DB

1856 Views

Hi,

We want to copy 16 billion records from one table to another table in HANA DB. At the moment it takes 6 hours to copy 2 billion records. At this rate we might need couple of days to complete this activity. Is there a faster way to achieve the same?

Our table are range partitioned and we are using following code:

INSERT INTO "SAPABAP1"."TABLE1" ( SELECT * FROM "SAPABAP1"."TABLE1_BCKUP" );

we are on HANA 2.0 and DB version 30 and SP03.

Thanks