Is it possible to rename a SAP HANA Schema? If yes how it can be done?
We cannot directly rename schema in HANA it is not possible but it can be renamed if we export schema as binary and import it with the "WITH RENAME SCHEMA"option.
Please follow the below steps to rename the HANA Schema
1. Right click on the SCHEMA you want to rename and then select Export
2. Click next
3. Select BINARY as table format, please check "Including dependencies" & "Include data". Then choose one of the offered export locations and click finish.
Note: The export location you choose should be an empty directory.
4. Now open a new SQL command window and execute the statement: IMPORT "OBJECT" FROM 'PATH'. For example "Object" the Schema name is "SCHEMANAME" and the 'Path' is /Saphana/schema-export. So our statement looks like this:
IMPORT "SCHEMANAME"."*" FROM '/Saphana/schema-export' WITH RENAME SCHEMA SCHEMANAME TO SCHEMANAME2. SCHEMANAME2 is renamed new schema name, in a new Catalog.
5. At last we have to execute the statement via the green button or F8, and then refresh the Catalog list.
Sign up for STechies
Ask Question From Our Experts
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.