How to create a new database in oracle sql developer

To create a new database in Oracle SQL Developer, follow these steps:

Step 1: Launch Oracle SQL Developer

Open Oracle SQL Developer on your computer. If you don't have it installed, you can download it from the Oracle website.

Step 2: Connect to the Oracle Database

In the Oracle SQL Developer welcome screen, click on "Connect to Database" and enter the following information:

• Hostname: The hostname or IP address of your Oracle database server.
• Port: The port number used by your Oracle database server (default is 1521).
• SID: The system identifier of your Oracle database (e.g., ORCL).
• Username: The username to use for the connection (e.g., SYSTEM).
• Password: The password for the username.

Click "Connect" to establish a connection to the database.

Step 3: Create a New Database

Once connected, click on "Tools" in the top menu bar and select "Database" > "Create Database".

Alternatively, you can also use the "Create Database" button in the "Database" tab of the Oracle SQL Developer main window.

Step 4: Enter Database Details

In the "Create Database" dialog box, enter the following information:

• Database Name: Enter a name for your new database (e.g., MYDB).
• Database Administrator: Enter the username and password for the database administrator (e.g., SYSTEM).
• Database Type: Select the type of database you want to create (e.g., Multitenant).
• Storage: Select the storage options for your database (e.g., File-based storage).

Click "Next" to proceed.

Step 5: Set Database Options

In the "Database Options" dialog box, you can set various options for your database, such as:

• Character Set: Select the character set for your database (e.g., AL32UTF8).
• National Character Set: Select the national character set for your database (e.g., AL16UTF16).
• Time Zone: Select the time zone for your database.

Click "Next" to proceed.

Step 6: Create the Database

Review the database details and options, then click "Finish" to create the database.

Step 7: Verify the Database Creation

Once the database is created, you can verify it by clicking on "Tools" > "Database" > "Database Home" and selecting your new database from the list.

That's it! You have successfully created a new database in Oracle SQL Developer.