CREATE DATABASE creates a new database in PolarDB for Oracle.
Prerequisites
Before you begin, make sure that you have:
Superuser privileges, or the
CREATEDBpermission granted to your roleEnough disk space on the instance to accommodate the new database
Syntax
CREATE DATABASE nameParameters
| Parameter | Description |
|---|---|
name | The name of the database to create. |
Usage notes
Non-superusers with the
CREATEDBpermission can only create databases that they own.CREATE DATABASEcannot run inside a transaction block.
Examples
To create a database named testdb:
CREATE DATABASE testdb;