Re: Two Oracle admin questions.

I am not sure about Number 1, but I think you have to explicitly set tablespace privileges, though I could be wrong.

As for Number 2, Oracle looks for the initsid.ora file in the $ORACLE_HOME/dbs directory. For administrative purposes, I keep the actual initsid.ora file elsewhere. I create a softlink in the $ORACLE_HOME/dbs directory to point to the file.

HTH,
Patrick

In article <8frnjm$910$1_at_nnrp1.deja.com>,   alan_psb_at_yahoo.com wrote:
> Hello all,
>
> I have two questions: (Oracle 8.0.5 on Solaris)
>
> 1) I got error message when I created a table:
>
> ORA-01950: no privileges on tablespaces 'USERS';
>
> However, when I type "select * from user_role_privs", I see that I
> have the RESOURCE and CONNECT role.
>
> I through with RESOURCE role, I have the unlimited quota on all
> tablespaces. Why I cannot create objects on tablespace 'USERS'
> (tablespace USERS has free spaces)? And what can I do such that I can
> create objects on tablespace 'USERS'?
>
> 2) When I type "startup" in svrmgrl, Oracle cannot find the
 initsid.ora
> file. I can only startup the Oracle instance by specify the path of
 the
> initsid.ora (startup mount pfile=...). What can I do such that I don't
> need to specify the path of the initsid.ora to start the instance? (I
> have already set the ORACLE_SID variable before using svrmgrl).
>
> Thanks,
> Alan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 16 2000 - 00:00:00 CDT