Unable to add file to a Tablespace; insufficient privileges

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
Unable to add file to a Tablespace:

When trying to add a file to a Tablespace in the Production region using util/o/13/3 we get the following error:
ORA 0130: insufficient privileges
Idle> SP2 - 0640 – not connected.

Resolution:
I believe this is like the case with "Oracle Auditing" today:... user ALEPH_DBA is not granted with the sysdba privilege.

In order to fix this, you should log on as sys:

> su - root
Password:
root@xxx~ # sudo su - oracle
Execute oracle cshrc
...
oracle@xxx ~$ sqlplus '/as sysdba'

and do:

SQL>grant sysdba to aleph_dba

Article last edited: 3/4/2014