Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

scott user

I created a database using dbca that db has no SCOTT user..

If I create a file named scott.sql according to the link below.

can we create user scott..
0
walkerdba
Asked:
walkerdba
1 Solution
 
sdstuberCommented:
look in

${ORACLE_HOME}/sqlplus/demo/demobld.sql

11g no longer comes with the scott/tiger script though, instead the suggested demos are the HR, OE, SH schemas

if you want to create scott and you don't have the old script, you can find it on many sites, including the oracle forums

for example:
https://forums.oracle.com/forums/thread.jspa?threadID=2319119
0
 
walkerdbaAuthor Commented:
you are correct..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now