Oracle 11g Express – Installing Scott Schema

oracleoracle-11g-r2oracle-xe

I want to install scott schema, a sample database in oracle.

But in express edition, I can't find out it.

Please help me install it on Oracle 11g express.

I'm a newbie, pls help me

Best Answer

In fact I too came here to build a sample DB for scott schema in Oracle_v11g. I couldn't find DBCA as told above, but on further search, I found a file called scott.sql. It had lines to create the needed DB. So I connected to Oracle as system and ran it - all the tables were created. Now I couldn't connect using Scott as Id. Changed the password in System schema:

alter user scott identified by tiger;

Now I could login and access the needed tables from scott. Hope anyone looking for this might find this info useful.

Related Question