SQL Developer


How to compile all invalid objects in SQL Developer


Hi
I am used to PL\SQL Developer and currently I am testing SQL Developer (version 2.1). I have question where can I find in SQL Developer functionality (or how to invoke those functions) like:
1 ) To list all invalid objects and then compile them.
2) Invoke window similar to “Command window” in PL\Sql Developer
Thanks for help
Groxy 
To list invalid objects:
SELECT owner, object_name, object_type
FROM dba_objects
WHERE status = 'INVALID';To fix them use utl_recomp.recomp_parallel or utl_recomp.recomp_serial
depending on your requirements 
I woudl like to know how to compile all abject using GUI of SQL Developer if possible? 
Right-click on each node (like Procedures) and Compile Invalid. To view them just expand the node and observe the icon.
Have fun,
K. 
Or you could use the Compile All option ;-) 
Compile all is as likely to break things as fix them depending on dependencies. It is always best to either compile one at a time or to use UTL_RECOMP. 
Could I please revive this and ask how do I use UTL_RECOMP?
Also, I could not find a description of the icons in SQL Developer. Some procedures are shown with a green plus sign (I am guessing here since I can't make out what it is) on them and the ones that I right-click and compile have this green go away. Can you explain?
Thanks a lot. 
Procedures with a green sign are procedures compiled for debug (it's actually a small green bug not really a plus sign but it's easily mistaken since it's so small).

Related Links

Connecting to Oracle 8 DB with sql developer 1.5.5
problem running Sqldeveloper without admin privilege
Explain plan window, "operation" column is very narrow in 2.1 EA2
2.1 EA1/EA2/RC1: Constraints tab query bug [Fixed 2.1.1]
Database diferences
DDL for Grants
EA2: Auto Group By
Max Date function by Group is not catching a Null Date
finding a function name in PL/SQL Developer
How can I Connect SQL developer to JavaDB?
Execution of 1 jobs failed
2.1 EA2: is it possible to pass current line number to external tool
Suggestions Page???
How to convert MS Access to Xml file and Migrate to Oracle 10g ?
Error, connecting to the database!
2.1 EA2 - Better support for Schema jumpers (nice to have)

Categories

ORACLE DEV
Development Tools
Oracle Community (OTN)
E-Business Suite Techn...
Advanced Queueing
E-Business Suite Archi...
Projects
Workspace Manager
Industries Archived Fo...
Customers
Learning Management
Consumer Sector Collab...
Data Guard
Oracle Database Expres...
MapViewer
SQL Developer
Developer Suite (Korean)
Oldies but Goodies (Ko...
E-Business Suite on Or...
Documaker
Coherence
Process and Integration
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
Publisher Office Add-i...
WebLogic Real Time New...
Liquid Infrastructure ...
BEA WebLogic Portal (C...
LCM: Oracle Applicatio...
Primavera P3 User Comm...
Generics
Javadoc Tool (Develope...
New To Java Technology...
Java System Applicatio...
Blades General Discussion
Java Enterprise System...
ミドルウェア
Oracle WebLogic Server...
Information Discovery
Calc Manager
Oracle Social Network
Webservice(SOA) (Korean)
Oracle Coherence (MOSC...
Oracle User Group Comm...
Architecture - General...
Engineered Systems
Database Track
Oracle Fusion Middlewa...
Code It
Imagine It
AppCloud
Social Media Hub
Eloqua Users - Virginia
Eloqua Users with MS C...
Webcast Central
B2B Digital Marketing
SalesMastermind
Oracle Compute Cloud S...
Local Eloqua User Groups
SQL
Oracle Integration Clo...
Oracle Marketing Cloud...
Oracle Marketing Apps
SPARC Servers
Oracle SuperCluster
See How
LWUIT
JavaOne
Oracle EMEA Partner Sales
OU Guided Boot Camps
Article Archive
Korea Engineered Syste...
Java.net Forge Sunset
Oracle Cloud Developer...
NightHacking
Trade Promotions
Chile
Eloqua Benelux User Group
Find PLM Apps
JDeveloper and ADF
SQL and PL/SQL
Archived Forums
Fusion Middleware Arch...
Generic Linux
Discoverer
Life Sciences
Products (Korean)
SQLJ/ODBC (Korean)
기존 포럼(2006년 8월까지 게시물 T...
Communications Converg...
GRC General Discussion
中国移动Oracle技术论坛注册
Beehive
weblogic.developer.int...
aqualogic.bpm.administ...
dev2dev - BEA China
北京 User Group
JavaServer Faces
データベース一般
Desktop
OTN Garage
Imagine How

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App