Thursday 30 September 2010

Fix broken objects

From: http://forums.oracle.com/forums/thread.jspa?threadID=1319667&tstart=0

As sys user run:

@?/rdbms/admin/utlrp.sql

-- A check
col OBJECT_NAME for a30
select owner, object_name, object_type from dba_objects where status = 'INVALID';

Thursday 16 September 2010

UK Post

http://www.doogal.co.uk/UKPostcodes.php?Search=E1