Your table is already locked by some query. For example, you may have executed “select for update” and have not yet committed/rollbacked and fired another select query. Do a commit/rollback before executing your query.
More Related Contents:
- How to uninstall / completely remove Oracle 11g (client)?
- How can I set a custom date time format in Oracle SQL Developer?
- Get counts of all tables in a schema
- Determining location of relevant tnsnames.ora file
- Default row ordering for select query in oracle
- oracle convert unix epoch time to date
- Oracle trigger after insert or delete
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- Difference between a user and a schema in Oracle?
- Base64 encoding and decoding in oracle
- What is the dual table in Oracle?
- How to avoid variable substitution in Oracle SQL Developer
- Recursion In Oracle
- creating parameterized views in oracle11g
- Oracle’s default date format is YYYY-MM-DD, WHY?
- PL/SQL print out ref cursor returned by a stored procedure
- How to use a table type in a SELECT FROM statement?
- How to get primary key column in Oracle?
- Default Schema in Oracle Connection URL
- how to replace multiple strings together in Oracle
- How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
- Oracle: how to INSERT if a row doesn’t exist
- Valid Date Checks in Oracle
- Functions vs procedures in Oracle
- Oracle: difference between max(id)+1 and sequence.nextval
- HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
- Why cannot I create triggers on objects owned by SYS?
- automating rollback script oracle
- How do I get column datatype in Oracle with PL-SQL with low privileges?
- How to View Oracle Stored Procedure using SQLPlus?