Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create a Data base

sarada chellu - oracleMay 19 2011 — edited May 20 2011
Hi All,

I have installed oracle light OracleXE.exe.

Now i want to create a database where only specific user is allowed to that.

I have tried the below and it throws ORA-01501: CREATE DATABASE failed ,ORA-01100: database already mounted

CREATE DATABASE DEVFLX
USER NGPR2ST IDENTIFIED BY flx13
UNDO TABLESPACE undotbs
DEFAULT TEMPORARY TABLESPACE devflx;

Steps I followed
Step 1 - logged in to http://127.0.0.1:8080/apex/f?p=4500:1003:2716577582274117::NO::: with sys and password
Step 2 - Created a user NGPR2ST
Step 3 - create database where it fails.

Please help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2011
Added on May 19 2011
2 comments
441 views