svn commit: r412149 - in /incubator/lokahi/lokahi/trunk/database: install.sql packages.sql recompile.sql schema_priv.sql types.sql

[to...@apache.org]

Author: toback
Date: Tue Jun  6 08:27:25 2006
New Revision: 412149

URL: http://svn.apache.org/viewvc?rev=412149&view=rev
Log:
moved what was in types to packages, and added the other 3 to improve the install process

Added:
    incubator/lokahi/lokahi/trunk/database/install.sql
    incubator/lokahi/lokahi/trunk/database/recompile.sql
    incubator/lokahi/lokahi/trunk/database/schema_priv.sql
Removed:
    incubator/lokahi/lokahi/trunk/database/types.sql
Modified:
    incubator/lokahi/lokahi/trunk/database/packages.sql

Added: incubator/lokahi/lokahi/trunk/database/install.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/install.sql?rev=412149&view=auto
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/install.sql (added)
+++ incubator/lokahi/lokahi/trunk/database/install.sql Tue Jun  6 08:27:25 2006
@@ -0,0 +1,24 @@
+
+spool install.log
+
+@sequences.sql
+@tables.sql
+@triggers.sql
+@views.sql
+
+@packages.sql
+@functions.sql
+@procs.sql
+
+select status, count(*) from user_objects
+group by status
+/
+
+spool off
+
+@recompile.sql
+
+prompt *** Check ORA- Error in Log Files ***
+! grep ORA- install.log
+! grep ORA- recompile.log
+

Modified: incubator/lokahi/lokahi/trunk/database/packages.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/packages.sql?rev=412149&r1=412148&r2=412149&view=diff
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/packages.sql (original)
+++ incubator/lokahi/lokahi/trunk/database/packages.sql Tue Jun  6 08:27:25 2006
@@ -1,3 +1,9 @@
+
+CREATE TYPE BI_TYPE AS OBJECT ( COL1 VARCHAR2(2000), COL2 VARCHAR2(2000) );
+/
+CREATE TYPE BI_LIST AS TABLE OF BI_TYPE;
+/
+
 CREATE OR REPLACE PACKAGE tmctypes
 AS
     TYPE cursorType IS REF CURSOR;

Added: incubator/lokahi/lokahi/trunk/database/recompile.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/recompile.sql?rev=412149&view=auto
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/recompile.sql (added)
+++ incubator/lokahi/lokahi/trunk/database/recompile.sql Tue Jun  6 08:27:25 2006
@@ -0,0 +1,39 @@
+
+spool recompile.run
+set head off
+set feed off
+
+select 'alter '||object_type||' '||object_name||' compile;'
+from user_objects
+where status = 'INVALID'
+and   object_type in ( 'FUNCTION', 'PROCEDURE', 'VIEW', 'PACKAGE', 'PACKAGE BODY' )
+/
+spool off
+
+set echo on
+set feed on
+
+spool recompile.log
+
+@recompile.run
+
+set head on
+set echo off
+
+prompt *** Install Status ***
+
+select object_type, status, count(*) from user_objects
+group by status, object_type
+/
+
+prompt *** List of Invalid Objects ***
+
+select object_type, object_name, status from user_objects
+where status = 'INVALID'
+/
+
+prompt *** End of Install ***
+
+spool off
+
+

Added: incubator/lokahi/lokahi/trunk/database/schema_priv.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/schema_priv.sql?rev=412149&view=auto
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/schema_priv.sql (added)
+++ incubator/lokahi/lokahi/trunk/database/schema_priv.sql Tue Jun  6 08:27:25 2006
@@ -0,0 +1,13 @@
+def owner=&1
+
+set verify off
+
+grant create session     to &owner;
+grant create table       to &owner;
+grant create procedure   to &owner;
+grant create view        to &owner;
+grant create sequence    to &owner;
+grant create type        to &owner;
+
+
+