Create Schema in oracle 10g express edition

oracle10g oracle-xe
ramesh picture ramesh · Aug 9, 2010 · Viewed 31.1k times · Source

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 else I have to install other oracle 10g..?

To create schema which oracle 10g I have to install... what?

Answer

zendar picture zendar · Aug 9, 2010

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.

Related questions

Oracle XE 10g Ubuntu removed from oracle web site?

I can't find Oracle XE 10g anymore on Oracle web site. I'm using 32 bit GNU/Linux Ubuntu 12.04. There's only 11g xe version on they'r website, that I can't install under my operating system. Does somebody have this distribution? Could you …

Read More
How to connect to newly installed Oracle XE instance?

I have installed Oracle XE on Win7 x64 machine. Installation completed successfully without problem, or perhaps installer didn't tell about them. But after installation I can't connect to database; its web interface is not working. I have looked through list …

Read More
Create date from year, month and day

Does Oracle have a builtin function to create a date from its individual components (year, month and day) that just returns null on missing data? I'm aware of TO_DATE() but I need to compose a string first and neither …

Read More