What is the method to create a new database in Oracle?

To create a new database in Oracle, you can follow these steps:

1. Log in to tools such as SQL*Plus or SQL Developer on the Oracle database server.
2. Log in to the Oracle database with administrator privileges.
3. To store the data and objects of a new database, you can create a new tablespace using the following SQL statement:

CREATE TABLESPACE my_new_tablespace DATAFILE 'my_new_tablespace.dbf' SIZE 100M;

1. Create a new user (schema) to own all objects in a new database. You can use the following SQL statement to create a new user:

CREATE USER my_new_user IDENTIFIED BY my_password DEFAULT TABLESPACE my_new_tablespace;

1. Grant necessary permissions to new users, such as connect, create table, and insert permissions. You can use the following SQL statement to grant permissions:

GRANT CONNECT, RESOURCE TO my_new_user;

1. Create new database objects such as tables, views, indexes, etc. You can use SQL statements like CREATE TABLE, CREATE VIEW to create these objects.
2. Finally, remember to submit all the changes.

COMMIT;

By following the steps above, you can successfully create a new database in Oracle.