Cause: The number of temporary tables equals or exceeds the number of
temporary table locks. Temporary tables are often created by
large sorts.
Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization
parameter and warm start.
Related posts
12c New Features – Database In-Memory
Resolving tablespace issues (ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658)
Troubleshooting Listener Startup or Connection Hang issues in 11g.
Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514
Oracle datapump Architecture & Internals
Oracle datapump Internals
Install & Configure Oracle XE on Linux/CentOS in less than a minute.
Resolving ORA-00845: MEMORY_TARGET not supported on this system
How to read Datapump Dumpfile Headers
Oracle Database Internal Mechanism 