Oracle User Scott not accessing

Asked By 140 points N/A Posted on -
qa-featured

Hi,

I am using Oracle to learn SQL. Just introductory. I downloaded the Oracle setup file from Oracle's homepage named – "oracleXE 10g". The software installed successfully, but I don't seem to find the user Scott, which was used in the class lecture. I missed the lecture so could not figure out if there was anything said which was not covered in the papers. I asked a partner who said it was a default user. Then why can't I access it? Do I need a configuration or something to be set up at the beginning? Or am I using the wrong version? The instructor said in the paper that it was 10g, are there any variance within 10g?

SHARE
Best Answer by technical007
Answered By 0 points N/A #91839

Oracle User Scott not accessing

qa-featured

Scott user is not in the default user list bundled in Oracle XE. You have to create it manually or by running a script. Go here to download the script.

First of all, create a user named, Scott and password, Tiger or as you wish. Log into it and the run the script on your SQL command line.

Answered By 140 points N/A #91842

Oracle User Scott not accessing

qa-featured

Thanks for the answer. The link seems broken. Would you please post the link again?

Answered By 0 points N/A #91844

Oracle User Scott not accessing

qa-featured

There is a script here, which shall create all the tables and data along with it: http://cvs.zope.org/*checkout*/Products/DCOracle2/test/scott.sql?rev=1.2.2.1. You have to create the user first manually.

Answered By 140 points N/A #91845

Oracle User Scott not accessing

qa-featured

Thanks. I have created a user named Scott but it doesn't let me log in.

Best Answer
Best Answer
Answered By 0 points N/A #91846

Oracle User Scott not accessing

qa-featured

That is because you have to grant some permission to it. Here is a script that does everything, you shall find it in the 3rd post :

http://www.dbasupport.com/forums/showthread.php?34990.html

  • Copy Script , save it in a text file, with extension " .sql ".   When done, open up the SQL command prompt.
  • connect  sys as sysdba   and give password

If you already have a user named Scott, you may want to drop it first. Issue :

  • drop user scott cascade
  • Now enter the character  '@' the command prompt and drag and drop the scriptfile.sql you just created.
  • Press enter.

It will take a while till your user is up and ready.

Answered By 140 points N/A #91847

Oracle User Scott not accessing

qa-featured

Thanks, technical007 and softwaresynthesis, both of you. I got my problem solved!

Login/Register to Answer

Related Questions