Create Schema in oracle 10g express edition

Question

Hi

I have installed oracle 10g express edition and i did not find the option to create schema..is there a option to create schema in oracle 10g express edition or esle i have to install other oracle 10g..To create schema which oracle 10g i have to install...

Thanks in advance

Answer 1

You don't need to explicitly create schema, Oracle automatically creates a schema when you create a user (see CREATE USER documentation).

If you really want, you can use CREATE SCHEMA statement and issue it through Oracle Express web interface or from SQL prompt.

Answer 2

As zendar said, creating a user automatically creates their schema (in Oracle these are pretty much the same concept).

When you create a Workspace in apex, it will ask you if you want to use an existing schema or create a new one - so that's another easy option you could use.