set serveroutput on ;
set define off;
set feedback off;
--
--
--
exec dbms_output.put_line ('======================================');
exec dbms_output.put_line ('q02b_pre_0001_data.sql: INICIO DE EJECUCION');
exec dbms_output.put_line ('======================================');
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE USUARIOS');
exec dbms_output.put_line ('==================');
--ALTER TABLE Q021JT00 disable CONSTRAINT FK_Q022FT00_01;
--truncate table Q022FT00;
--ALTER TABLE Q021JT00 enable CONSTRAINT FK_Q022FT00_01;
delete from Q022FT00;
@insert_usuarios.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE INFORMES');
exec dbms_output.put_line ('==================');
truncate table Q022NT00;
@insert_Q022NT00.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE CÓDIGOS');
exec dbms_output.put_line ('==================');
truncate table Q022OT00;
@insert_Q022OT00.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE Cabecera de Tabla de Tablas');
exec dbms_output.put_line ('==================');
truncate table Q022XT00;
@insert_Q022XT00.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE Elementos de Tabla de Tablas');
exec dbms_output.put_line ('==================');
truncate table Q022YT00;
@insert_Q022YT00.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE MODULOS');
exec dbms_output.put_line ('==================');
--ALTER TABLE Q021FT00 disable CONSTRAINT FK_Q021ET00_01;
--truncate table Q021ET00;
--ALTER TABLE Q021FT00 enable CONSTRAINT FK_Q021ET00_01;
delete from Q021ET00;
@insert_Q021ET00.sql;
--
--
--
exec dbms_output.put_line ('==================');
exec dbms_output.put_line ('CREACION DE PROCESOS');
exec dbms_output.put_line ('==================');
--ALTER TABLE Q021LT00 disable CONSTRAINT FK_Q021FT00_01;
--truncate table Q021FT00;
--ALTER TABLE Q021LT00 enable CONSTRAINT FK_Q021FT00_01;
delete from Q021FT00;
@insert_Q021FT00.sql;
--
--
--
exec dbms_output.put_line ('===================================');
exec dbms_output.put_line ('q02b_pre_0001_data.sql: FIN DE EJECUCION');
exec dbms_output.put_line ('===================================');
set serveroutput off;
commit;
exit;