Re: How to extend a table space

Your OS user is probably not a member in the Oracle DBA OS group (the group that owns Oracle executables). So you can either add your user to that group (then, you can just do "connect / as sysdba;") or try connecting as SYS or SYSTEM using the appropriate passwords.

Thanks.
Alex.

Sambavan Tharmarajah wrote:

> Hi,
>
> I need to extend my default table space. I tried to extend it through the
> sqlplus and I was getting an error stating that I don't have the DBA
> privilages. I can get to the super user level, but there I couldn't invoke
> the sqlplus.
>
> This is what I tried trping at the superuser prompt.
>
> database_name# sqlplus
>
> So could anyone tell me, how to go about with this problem. I have no
> clue on this of what/where/how to do this.
>
> Thanx,
>
> Sam .T
>
> 600 West 26Th Street, Phone : (512) 474-2328
> Apartment #E 144, E-mail: sambavan_at_cs.utexas.edu
> Austin, sambavan_at_mail.utexas.edu
> Texas - 78705. sambavan_at_tenet.edu
>
> -------------------------------------------------------
>
> You should treat all disasters as if they were
> trivialities but never treat a triviality as if
> it were a disaster
>
> --- QUENTIN CRISP.
> --------------------------------------------------------
Received on Tue Oct 26 1999 - 17:02:08 CDT