Created
April 21, 2017 22:31
-
-
Save oliworx/13f0867178390bbbbb78026e39085ce5 to your computer and use it in GitHub Desktop.
How to create and dropa SAP HANA tenant database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- source: https://blogs.sap.com/2016/10/27/create-tenant-database-sap-hana-express-sap-hana-academy/ | |
-- create a tenant | |
CREATE DATABASE TESTDB SYSTEM USER PASSWORD Initial1; | |
-- add the script server service | |
ALTER DATABASE TESTDB ADD 'scriptserver' | |
-- or hit two birds with one stone | |
CREATE DATABASE TESTDB ADD 'scriptserver' SYSTEM USER PASSWORD Initial1; | |
-- Tenants by default start automatically, but can be started and stopped manually as well | |
ALTER SYSTEM START DATABASE TESTDB; | |
-- Stop before you drop | |
ALTER SYSTEM STOP DATABASE TESTDB; | |
DROP DATABASE TESTDB; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment