59 lines
1.5 KiB
Plaintext
59 lines
1.5 KiB
Plaintext
--
|
|
-- Recreate script van Facilitor Care-Webb
|
|
--
|
|
/*
|
|
* This script is precompiled
|
|
* C-style comment is removed from the result
|
|
*/
|
|
#include "modules.h"
|
|
#include "comsql.h"
|
|
|
|
SET TERMOUT ON
|
|
SET FEEDBACK OFF
|
|
SET ECHO OFF
|
|
SET PAGESIZE 0
|
|
SPOOL OFF
|
|
SET HEADING OFF
|
|
SET DEFINE OFF
|
|
PROMPT ***********************************************************************
|
|
PROMPT
|
|
PROMPT RECREATE SCRIPT van Facilitor Care-Webb
|
|
PROMPT $Revision$
|
|
PROMPT $Id$
|
|
PROMPT
|
|
PROMPT Re-creeert alle algemene views, etc van Facilitor Care-Webb schema _DBV
|
|
PROMPT
|
|
PROMPT Het wordt aangeraden om deze upgrade te draaien op een moment dat er
|
|
PROMPT geen gebruikers bezig zijn met de applicatie.
|
|
PROMPT
|
|
PROMPT De recreate wordt uitgevoerd. Even geduld a.u.b...
|
|
PROMPT
|
|
|
|
SET TERMOUT ON
|
|
SET HEADING OFF
|
|
SET FEEDBACK ON
|
|
SET ECHO ON
|
|
SET VERIFY OFF
|
|
SET LINESIZE 1000
|
|
SET SERVEROUTPUT ON;
|
|
|
|
SET DEFINE ON
|
|
column fcltlogfile new_value fcltlogfile NOPRINT;
|
|
select 'RECARE'|| '_' || UPPER(USER || '_' || sys_context('USERENV', 'SERVICE_NAME') || '_' || sys_context('USERENV', 'SERVER_HOST')) || '_' || to_char(sysdate,'YYYYMMDD_HH24MISS') || '.lst' as fcltlogfile from dual;
|
|
spool &fcltlogfile
|
|
SET DEFINE OFF
|
|
|
|
#include "care\care_vie.src"
|
|
#include "care\care_pac.src"
|
|
|
|
/* now compile all views, triggers etc acc to the latest state */
|
|
BEGIN DBMS_UTILITY.COMPILE_SCHEMA(USER, FALSE); END;
|
|
/
|
|
|
|
REGISTERONCE('$Id$')
|
|
|
|
SPOOL OFF
|
|
SET DEFINE ON
|
|
SET ECHO OFF
|
|
PROMPT De care-webb recreate is gereed.. Controleer de LST-file.
|