By Edward Stoever
Team coding is a great feature of TOAD.
It prevents two people from
working on the same PL/SQL code at the same time and thus
overwriting each other's work.
It does have its drawbacks. You
should never check out code that was provided with your ERP
application. Recently, we ran into this exact scenario. An ERP
package was checked out and compiled with the debug option on. Doing
so locked up all other objects that were dependent on it and we
couldn't check out what we needed to with TOAD. We needed to
recompile that package bypassing TOAD's Team Coding feature.
I bypassed Team Coding by taking a copy of the code from our
production database and placing it into a SQL editor window. At the
beginning, I typed in the command "set define off;" and ran it as a
script. This overwrote the package and compiled it clean, unlocking
all dependant objects! ("set define off;" forces TOAD to compile the
code as is, without asking to replace any strings that include an
ampersand).
|
|
 |
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
|
|
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
| |
| |
Copyright ©
1996 -2011 by Burleson Enterprises. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Corporation.
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks
|
|
