How to create new database in oracle 10g manually

 · That is, you have established the environment for creating your Oracle Database, including most operating system dependent environmental variables, as part of the Oracle software installation process. Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication www.doorway.ruted Reading Time: 9 mins.  · In order to create a database you have to start an instance without mounting a database and then issue the create databse command. $ SQLPLUS /nolog CONNECT SYS/password AS SYSDBA STARTUP NOMOUNT CREATE DATABASE Reviews: 1.  · Even if your company standardizes on using the GUI tools, such as DBCA, it would be a good idea to create a database manually at least once, not only to help.

Even if your company standardizes on using the GUI tools, such as DBCA, it would be a good idea to create a database manually at least once, not only to help. Video tutorial for creating new database in Oracle 10g. This section presents the steps involved when you create a database manually. These steps should be followed in the order presented. Before you create the database make sure you have done the planning about the size of the database, number of tablespaces and redo log files you want in the database.

As an Oracle database user, you can create a new user and modify manually specify the access rights the new user has to a specific schema and database. I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database. Use Oracle Database Assistant to create a database because it is the This section describes the steps to create a database manually using a SQL script.