Installation Guide › WebSphere Version › Separate Database Configuration › How to Create Separate Databases › Create an Oracle Database Instance

Create an Oracle Database Instance

Follow these steps:

1. Create a new tablespace.
2. Create a new user.
3. Grant the user rights to the new database.
   • Create/alter/drop tables
   • Create/alter/drop view
   • Create/alter/drop INDEX
   • Create/replace/drop stored procedures
   • Create/replace/drop functions
   • Create/drop sequence
   • Create/replace/drop triggers
   • Create/replace/drop types
   • Insert/select/delete records
   • CREATE SESSION / connect to database
4. Give DBA rights to the user.

Note: For complete information about Oracle, see your Oracle documentation.