However, if you specify either clause, you must specify both clauses. These clauses are not mandatory in this release. Use these clauses to establish passwords for the SYS and SYSTEM users.
![create database in oracle 10g create database in oracle 10g](https://i.ytimg.com/vi/2SwAsDuKj-4/maxresdefault.jpg)
Please refer to "Schema Object Naming Guidelines" for additional rules to which database names should adhere. The DB_NAME initialization parameter must be set in the database initialization parameter file, and if you specify a different name from the value of that parameter, then the database returns an error. If you omit the database name from a CREATE DATABASE statement, then Oracle Database uses the name specified by the initialization parameter DB_NAME. For example, characters with umlauts are not allowed. You cannot use special characters from European or Asian character sets in a database name. If you specify the database name as a quoted identifier, then the quotation marks are silently ignored. The database name is case insensitive and is stored in uppercase ASCII characters.
![create database in oracle 10g create database in oracle 10g](https://fiverr-res.cloudinary.com/images/q_auto,f_auto/gigs/121874104/original/b4d1a1a3315b230a88ceacefd311bda7bb7807f7/create-and-manage-your-oracle-10g-database.png)
If you subsequently issue an ALTER DATABASE statement that explicitly specifies a database name, Oracle Database verifies that name with the name in the control file. Oracle Database writes this name into the control file. The name can be up to 8 bytes long and can contain only ASCII characters. The name must match the value of the DB_NAME initialization parameter. Specify the name of the database to be created. ( file_specification::=, default_tablespace ::=, default_temp_tablespace ::=, undo_tablespace ::=)ĭescription of the illustration default_tablespace.gifĭescription of the illustration default_temp_tablespace.gifĭescription of the illustration extent_management_clause.gifĭescription of the illustration undo_tablespace.gifĭescription of the illustration set_time_zone_clause.gif ( database_logging_clauses::=, tablespace_clauses::=, set_time_zone_clause ::=)ĭescription of the illustration database_logging_clauses.gifĭescription of the illustration tablespace_clauses.gif To create a database, you must have the SYSDBA system privilege.ĭescription of the illustration create_database.gif Oracle Database Java Developer's Guide for information on creating an Oracle Java virtual machineĬREATE TABLESPACE for information on creating tablespaces
![create database in oracle 10g create database in oracle 10g](https://docs.oracle.com/cd/E17781_01/admin.112/e18585/img/sqldev_window.jpg)
ALTER DATABASE for information on modifying a database