how to enable buildt-in users in Oracle 9i

[lhugh]

** My first question is: how come Oracle 9i does not have user Scott? Which user is replacing Scott (I look for Scott in DBA_USERS table, can't find him)

** There are a few users that come with Oracle 9i but are not enabled. How do I enable these users? For example user HR?

Thanks

 

[SantaMufasa]

To enable pre-installed (disabled) user accounts, use this syntax:

&quot;alter user <username> account unlock;&quot;

I don't know why SCOTT isn't a continuing tradition. What functionality were you looking for in the SCOTT account?

Dave
Sandy, Utah, USA @ 19:55 GMT, 12:55 Mountain Time

 

[lhugh]

Thank you Dave.

I was trying to buid some &quot;quick and dirty&quot; tables using Scott's tables, Oracle wouldn't let me do that.

(create table table_name as (select * from scott.emp where 1=2);

 

[sem]

Are you sure you installed example schema(s)? What is error code/message?

Regards, Dima

 

[SantaMufasa]

LHugh,

If you are looking for a self-contained application's-worth of data (similar to SCOTT's). I have the scripts to install (and remove) the Summit Sporting Goods tables for the Oracle Education classroom application. The tables are fully populated copies of (alphabetically) CUSTOMER, DEPT, EMP, INVENTORY, ITEM, ORD, PRODUCT, REGION, TITLE, WAREHOUSE. The script defines and enables all of the declarative constraints (Primary Key, Foreign Key, Unique Key, and Check/Not Null). You can install these tables in any Oracle user schema.

If you want them, post me a target.

Dave
Sandy, Utah, USA @ 18:41 GMT, 11:41 Mountain Time

 

[lhugh]

Dave

That script sounds good. Please send it to me at lhugh@hotmail.com

Thanks

Hugh