ORA-01031: insufficient privileges
Cause: The error will occur when a user tries to create an object and the user
does not have the privilege to create one.
For example:
Suppose you just create a new user called test1.
Then test1 logins and tries to create a simple table called t1.
But as the user does not yet have privilege to create an object (even in his own schema),
the error ORA-01031: insufficient privileges will be encountered.
[oracle@HOST1 ~]$ sqlplus / as sysdba
SQL> create user test1 identified by test1;
ORA-00942: Table or View does not exist
ORA-00942: Table or View does not exist
Cause of error: Oracle table or view does not exist in the database.
Oracle database privileges are missing or granted incorrectly.
Actions to take: Make sure that the table or view or synonym that you are referencing exists in the database and ensure they have necessary privileges.
For example if you try to access a table or view from another schema and you do not have select privilege to that table or view then you will get this error message. Even if you specify the table or view name using the schema name- you will still get this error.
Lets’ say there is a table called table1 in a schema called schema1. There is another schema called schema2. At the moment you are in Oracle schema2 and want to execute an Oracle select statement on table1 such as
select * from schema1.table;
But if you do not have Oracle select privilege granted to you then you will get ORA-00942.
To fix that login to Oracle in your schema1 schema and then run the following statement to grant select privilege to schema2.
SQL> grant select on schema1.table1 to schema2;
Now you should be able to access table1 data from schema2 as long as you qualify the Oracle table name with the schema name i.e. schema1.table1. This query should return you data now.
select * from schema1.table; Continue reading
ORA-01552: cannot use system rollback
Problem:
Today I encountered an error in my oracle database which displays the error ORA-01552: cannot use system rollback.
I do not recollect experiencing this error before.
Investigation:
So I went to Google looking for an answer. In most of the posts in various forums the recommendation is
1. To create rollback segments
2. To make existing rollback segments online.
So I suspected my rollback segments are offline. But when I run the query
ORA-06512 at string line string Tips and Example
Cause: Backtrace message as the stack is unwound by unhandled exceptions. This is basically to indicate where a particular error number occurred in an operation.
Example 1:
declare
l_fname varchar2(3);
begin
l_fname := ‘abcd’;
end;
/
Continue reading
ORA-06502 PL/SQL: numeric or value error string – Tips and Example
Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Example 1:
declare
l_name varchar2(3);
begin
l_name := ‘abcd’ ;
end;
/
Recent Comments