3.3.3.6 DATABASE
You can add, alter, delete, or list the Oracle databases.
•
•
(page 3-50)
•
(page 3-51)
•
3.3.3.6.1 ADD DATABASE
This command adds an Oracle database, or a CDB or PDB to an existing CDB.
Syntax
ADD DATABASE
[ BLOCKSIZE = blocksize ]
[ CHARSET = database_character_set
DATADG = data_diskgroup
[ DBLANG = database_language ]
DBNAME = database_name
[ DBTEMPLATE = database_template ]
[ DBTYPE = database_type ]
[ HOSTNAMES = 'host_names' ]
RECODG = reco_diskgroup
WHERE
{ DBHOMEID = database_home_id |
CLUSTERNUMBER = cluster_number DBHOMELOC = database_home_location |
CLUSTERNAME = cluster_name DBHOMELOC = database_home_location |
CLUSTERID = cluster_id DBHOMELOC = database_home_location |
CLUSTERNUMBER = cluster_number CDBNAME = container_database_name |
CLUSTERNAME = cluster_name CDBNAME = container_database_name |
CLUSTERID = cluster_id CDBNAME = container_database_name }
Arguments
You can specify the following attributes for the new Oracle database:
•
BLOCKSIZE
: Specifies the block size for the new database. The default value is
8192. This argument is not required for pluggable databases.
•
CHARSET
: Specifies the character set to use for the new database. The default
value is
AL32UTF8
. This argument is not required for pluggable databases.
•
DATADG
: (Mandatory) Specifies the name of the DATA disk group for the new
database. This argument is not required for pluggable databases.
•
DBLANG
: Specifies the language to use for the new database. The default value is
all_langs
. This argument is not required for pluggable databases.
•
DBNAME
: (Mandatory) Specifies the name of the new database.
•
DBTEMPLATE
: Specifies the template to use when creating the new database,
ADMIN
or
DW
. The default value is
ADMIN
. This argument is not required for pluggable
databases.
•
DBTYPE
: Specifies the type of database to create. The accepted values are
normal
DB
,
CDB
, or
PDB
. The default value is
normal DB
.
Chapter 3
OEDA Command Line Interface
3-48
