Re: Oracle 8.1.5 -- set up admin account

In article <3a512740.10155472_at_enews.newsguy.com>,   m_010_at_yahoo.com (tim leung) wrote:
> Hi,
> I justed install oracle 8.1.5 enterprise on my win2000 machine. But It
> didn't ask me to set any administrator password. Any one knows how can
> I set an admin account that has all privilege.
>
> My friend told me to use scott / tiger to login to SQL*Plus. Is this
> the default account whenever I create a new DB? Does scott / tiger
> has all the admin privilege? When I login, is the host string is same
> as SID?
>
> I had create another DB and it show 3 accounts. What's the difference?
>
> INTERNAL : oracle
> SYS : change_on_install
> SYSTEM : manager
>
> When I take a look what's inside the database. It has many tables that
> I don't need. Any way I can create a DB without any tables in it,
> just like mySQL? Can I delete those tables? When I type:
>
> SQL> select table_name from all_tables;
> TABLE_NAME
> ------------------------------
> DUAL
> SYSTEM_PRIVILEGE_MAP
> TABLE_PRIVILEGE_MAP
> STMT_AUDIT_OPTION_MAP
> AUDIT_ACTIONS
> PSTUBTBL
> DEF$_TEMP$LOB
> DEPT
> EMP
> BONUS
> SALGRADE
> LOCATION
> DEPARTMENT
> JOB
> EMPLOYEE
> SALARY_GRADE
> PRODUCT
> PRICE
> CUSTOMER
> SALES_ORDER
> ITEM
>
> TABLE_NAME
> ------------------------------
> OGIS_SPATIAL_REFERENCE_SYSTEMS
> AURORA$IIOP$SYSTEM$PROPERTIES
> MD$DICTVER
> HELP
>
> 25 rows selected.
>
> Thanks.
>
>

Go on, ramble away and see what happens. But as Oracle is, unlike MySql, a professional system, you should RTFM before you do that. The Getting Started Manual, which you obviously didn't read, should answer most of your questions. If you didn't install them they are online at http://technet.oracle.com

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/