We can help. Together we learn....

Migrating tables to specified nodes in SAP HANA multi node system

by vinaysingh | Tuesday, August 06, 2013 in |

If you want to migrate a particular table from one node of HANA to another for performance or space issue :- 

1. To view current location  of table

open SQL editor on HANA studio and run the sql query :- 


select * from "SYS"."M_TABLE_LOCATIONS" order by LOCATION, table_name

2. To view current location  decide the node where you want to move it and run the below  query on SQL editor of HANA studio:- 

ALTER TABLE MOVE TO ‘node:port number’

7 comments:

  1. yektek training on April 8, 2014 at 8:40 AM

    nice post thanks for sharing from Swathi

     
  2. SWATHI BOPPUDI on December 4, 2014 at 4:47 PM

    Hi,
    nice information about sap hana for learners real time experienced experts provides online training on
    sap hana online training
    and also server access for pactice at training period

     
  3. Ramya k on May 20, 2016 at 11:13 AM

    Thanks for the great information in your blogSAP SD Training in Chennai

     
  4. RS Trainings on May 27, 2016 at 4:17 PM

    This is a great article man, thanks for the tips! It’s refreshing to learn so many new ways to kick off blog posts.
    best online MSBI training
    online abinitio training in usa,uk,india,canada
    selenium training
    best R programming online training
    SAP HANA online training in india

     
  5. sushma on August 11, 2016 at 10:53 AM

    Thanks for sharing this Informative content. Well explained.Got to learn new things from your Blog on SAP SD.
    SAP SD

     
  6. sushma on September 18, 2016 at 12:45 PM

    Great place to learn about the new things and got great knowledgeSAP MM Training in Chennai

     
  7. sanayamohit on October 7, 2016 at 10:33 AM

    Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP MM.
    SAP MM

     

Categories