Toad Detects No TNS ?
At the first time startup of Toad for Oracle, you may want to new a connection to start to use the tool. But sometimes, you… Read More »Toad Detects No TNS ?
Toad for Oracle
Toad Create Table Example
How to create a table in Oracle step by step? To create a new table, we can choose to compose a hand-writing PL/SQL statement which… Read More »Toad Create Table Example
Toad NLS_DATE_FORMAT
How do I Change NLS Date Format in Toad ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS level.… Read More »Toad NLS_DATE_FORMAT
Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
How Oracle Rename Table
You can either using SQL statement or GUI tools to rename a table, depending on your requirement. Table Rename by SQL Statement Table Rename by… Read More »How Oracle Rename Table
SYS_AUTO_SQL_TUNING_TASK Report
SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… Read More »SYS_AUTO_SQL_TUNING_TASK Report
How to Flip Vertical into Horizontal Layout in Toad
After your Toad for Oracle installed in a new computer, you may see a strange layout in Session Browser like mine. It's a vertical layout… Read More »How to Flip Vertical into Horizontal Layout in Toad
How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
Unable to find RAC connection information for INST_ID A developer tried to run a procedure with debug mode in Toad for Oracle, a database tool… Read More »How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
How to Resolve Toad Error ORA-00904: "REF": invalid identifier
Tried to display "Script" (DDL) of a table in Toad for Oracle, we saw ORA-00904: "REF": invalid identifier. Typically, ORA-00904 is an unmatched column issue,… Read More »How to Resolve Toad Error ORA-00904: "REF": invalid identifier
How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
JDBC ORA-12850 Some developers report ORA-12850 error in their JDBC log. ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated There… Read More »How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated