SQL Developer Explain Plan
For those who don't have GUI tools like SQL developer or Enterprise Manager, you can still get an explain plan for a statement in SQL*Plus.… Read More »SQL Developer Explain Plan
Tool
How to Resolve SP2-0618 and SP2-0611
SP2-0618 and SP2-0611 An user reported errors SP2-0618 and SP2-0611 when he tried to enable AUTOTRACE at his session-time. SQL> show user USER is "HR"… Read More »How to Resolve SP2-0618 and SP2-0611
Enable Non-Oracle User Run SQL*Plus
Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
SQL Developer Create Index Partition
Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »SQL Developer Create Index Partition
Toad No Valid Oracle Clients Found
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 No Valid Oracle Clients Found
PL/SQL Developer Initialization error, Oracle Client not properly installed
At the first time startup of PL/SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »PL/SQL Developer Initialization error, Oracle Client not properly installed
tnsnames.ora in SQL Developer
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »tnsnames.ora in SQL Developer
EM_EXPRESS_ALL, How and Why
EM_EXPRESS_ALL Whereas EM_EXPRESS_BASIC provides some basic privileges to monitor properties through EM, EM_EXPRESS_ALL, also an Oracle predefined role, has some more advanced privileges which enable… Read More »EM_EXPRESS_ALL, How and Why
EM_EXPRESS_BASIC, How and Why
Enterprise Manager (EM) Enterprise Manager (EM) is a graphical management tool that provides centralized capabilities of managing Oracle databases and servers. In recent releases, EM… Read More »EM_EXPRESS_BASIC, How and Why
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