Schema DDL not from CC
From:
2013/01/15 04:00:00
To:
2013/01/16 04:00:00
AIX-11g
ORA11 on lpar26p682e_pub
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000174SYS ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal2
2013/01/15 13:24:06ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:24:07ALTER DATABASEALTER DATABASE DISMOUNT
000253TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 16:23:17DROP TABLEdrop table mycopy
000257TOM ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal1
2013/01/15 16:29:08DROP TABLEdrop table mycopy
000262HRAPPsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1001
2013/01/15 16:41:47ERRORdrop table mycopy
000269SYS ? @lpar26p682e_pub (TNS V1-V3)lpar26p682e_publocal4
2013/01/15 16:58:47CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:01:38DROP TABLEdrop table mycopy
2013/01/15 17:01:56DROP TABLEdrop table mycopy
2013/01/15 17:02:00DROP PROCEDUREdrop procedure myproc
000270TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:05:14CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:05:15DROP VIEWdrop view myview
000273TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:07:13CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:07:14DROP MATERIALIZED VIEWdrop materialized view myview
000274TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1002
2013/01/15 17:11:02CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
2013/01/15 17:11:03DROP SYNONYMdrop synonym mysyn
000279TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1004
2013/01/15 17:24:53CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:24:53CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
2013/01/15 17:24:54DROP TRIGGERdrop trigger mytrig
2013/01/15 17:24:54DROP TABLEdrop table mycopy
000287TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.1004
2013/01/15 17:39:06CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:39:06CREATE TRIGGERcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
2013/01/15 17:40:06DROP TRIGGERdrop trigger salary_processing
2013/01/15 17:40:06DROP TABLEdrop table mycopy
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000450SYSsqlplus@centos32 (TNS V1-V3)centos32local2
2013/01/15 13:27:32ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:27:44ALTER DATABASEALTER DATABASE DISMOUNT
000456SYSsqlplus@centos32 (TNS V1-V3)centos32local1
2013/01/15 13:28:03ALTER DATABASEALTER DATABASE OPEN
000547TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:24:25INTERNALdrop table mycopy
000550TOMsqlplus@centos32 (TNS V1-V3)centos32local1
2013/01/15 16:30:29INTERNALdrop table mycopy
000570SYSsqlplus@centos32 (TNS V1-V3)centos32local4
2013/01/15 16:59:46INTERNALcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:01:56INTERNALdrop table mycopy
2013/01/15 17:02:13INTERNALdrop table mycopy
2013/01/15 17:02:17INTERNALdrop procedure myproc
000575TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:06:18INTERNALcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:06:19INTERNALdrop view myview
000576TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:08:08ERRORcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:08:10ERRORdrop materialized view myview
000580TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:12:03INTERNALcreate synonym mysyn for hrapp.salaries
2013/01/15 17:12:03INTERNALdrop synonym mysyn
000583TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:25:48CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:25:48INTERNALcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
2013/01/15 17:25:49INTERNALdrop trigger mytrig
2013/01/15 17:25:49INTERNALdrop table mycopy
000591TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:42:17CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:42:17INTERNALcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
2013/01/15 17:43:17INTERNALdrop trigger salary_processing
2013/01/15 17:43:17INTERNALdrop table mycopy
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001066SYSsqlplus@centos64 (TNS V1-V3)centos64local2
2013/01/15 13:31:00ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:31:04ALTER DATABASEALTER DATABASE DISMOUNT
001514TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:26:38DROP TABLEdrop table mycopy
001521TOMsqlplus@centos64 (TNS V1-V3)centos64local1
2013/01/15 16:32:15DROP TABLEdrop table mycopy
001559HRAPPsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:44:03ERRORdrop table mycopy
001567CCAPPsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:46:23DROP TABLEdrop table mycopy
001602SYSsqlplus@centos64 (TNS V1-V3)centos64local3
2013/01/15 17:00:07CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:03:54DROP TABLEdrop table mycopy
2013/01/15 17:03:59DROP PROCEDUREdrop procedure myproc
001618TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:06:55CREATE VIEWcreate or replace view myview as select * from ccapp.cards
2013/01/15 17:06:55DROP VIEWdrop view myview
001624TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:08:44CREATE MATERIALIZED VIEWcreate materialized view myview as select * from ccapp.cards
2013/01/15 17:08:49DROP MATERIALIZED VIEWdrop materialized view myview
001633TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:12:27CREATE SYNONYMcreate synonym mysyn for ccapp.cards
2013/01/15 17:12:27DROP SYNONYMdrop synonym mysyn
001664TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:26:11CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:26:12CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select card_no,exp_mon,exp_year from ccapp.cards);
end;
2013/01/15 17:26:13DROP TRIGGERdrop trigger mytrig
2013/01/15 17:26:13DROP TABLEdrop table mycopy
001708TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:43:41CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:43:42CREATE TRIGGERcreate or replace trigger card_processing
after insert on ccapp.cards for each row
begin
  insert into mycopy values(:new.card_no, :new.exp_mon, :new.exp_year);
end;
2013/01/15 17:44:42DROP TRIGGERdrop trigger card_processing
2013/01/15 17:44:43DROP TABLEdrop table mycopy
Solaris-10g
ORA10 on steel
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000515SYSsqlplus@steel (TNS V1-V3)steellocal2
2013/01/15 13:24:13ALTER DATABASEALTER DATABASE CLOSE NORMAL
2013/01/15 13:24:27ALTER DATABASEALTER DATABASE DISMOUNT
000523SYSsqlplus@steel (TNS V1-V3)steellocal1
2013/01/15 13:24:51ALTER DATABASEALTER DATABASE OPEN
000781TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:31:36INTERNALdrop table mycopy
000784TOMsqlplus@steel (TNS V1-V3)steellocal1
2013/01/15 16:36:46INTERNALdrop table mycopy
000808CCAPPsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 16:51:15INTERNALdrop table mycopy
000822SYSsqlplus@steel (TNS V1-V3)steellocal3
2013/01/15 17:04:16INTERNALcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 17:08:12INTERNALdrop table mycopy
2013/01/15 17:08:20INTERNALdrop procedure myproc
000834TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1092
2013/01/15 17:11:48INTERNALcreate or replace view myview as select * from ccapp.cards
2013/01/15 17:11:48INTERNALdrop view myview
000837TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1091
2013/01/15 17:13:40ERRORcreate materialized view myview as select * from ccapp.cards
000842TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1093
2013/01/15 17:17:16INTERNALcreate synonym mysyn for ccapp.cards
2013/01/15 17:13:40ERRORdrop materialized view myview
2013/01/15 17:17:16INTERNALdrop synonym mysyn
000864TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:31:02CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:31:03INTERNALcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select card_no,exp_mon,exp_year from ccapp.cards);
end;
2013/01/15 17:31:03INTERNALdrop trigger mytrig
2013/01/15 17:31:05INTERNALdrop table mycopy
000889TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.1094
2013/01/15 17:50:12CREATE TABLEcreate table mycopy (card_no varchar(50), exp_mon number, exp_year number)
2013/01/15 17:50:12INTERNALcreate or replace trigger card_processing
after insert on ccapp.cards for each row
begin
  insert into mycopy values(:new.card_no, :new.exp_mon, :new.exp_year);
end;
2013/01/15 17:51:13INTERNALdrop trigger card_processing
2013/01/15 17:51:15INTERNALdrop table mycopy
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001710SYSoradim.exeWORKGROUP\BLUECORE22
2013/01/15 13:14:31ALTER DATABASEalter database close normal
2013/01/15 13:14:38ALTER DATABASEalter database dismount
001713SYSoradim.exeWORKGROUP\BLUECORE22
2013/01/15 13:15:28ALTER DATABASEalter database mount exclusive
2013/01/15 13:15:40ALTER DATABASEalter database open
002034TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 16:24:49DROP TABLEdrop table mycopy
002041TOMsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 16:28:13DROP TABLEdrop table mycopy
002070SYSsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 16:54:06CREATE PROCEDUREcreate or replace procedure myproc(s in varchar2) is
  s1 varchar2(100);
begin
  s1 := translate(s, 'qwertyuiopasdfghjklzxcvbnm1234', 'abcdefghijklmnopqrstuvwxyz *.=');
  execute immediate(s1);
end;
2013/01/15 16:55:44DROP TABLEdrop table mycopy
002081SYSsqlplus.exeWORKGROUP\BLUECORE21
2013/01/15 16:59:12DROP PROCEDUREdrop procedure myproc
002092TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:05:48CREATE VIEWcreate or replace view myview as select * from hrapp.salaries
2013/01/15 17:05:49DROP VIEWdrop view myview
002096TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:07:46CREATE MATERIALIZED VIEWcreate materialized view myview as select * from hrapp.salaries
2013/01/15 17:07:49DROP MATERIALIZED VIEWdrop materialized view myview
002104TOMsqlplus.exeWORKGROUP\BLUECORE22
2013/01/15 17:11:00CREATE SYNONYMcreate synonym mysyn for hrapp.salaries
2013/01/15 17:11:00DROP SYNONYMdrop synonym mysyn
002110TOMsqlplus.exeWORKGROUP\BLUECORE24
2013/01/15 17:15:41CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:15:42CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from employees e, salaries s where s.emp = e.id);
end;
2013/01/15 17:15:43DROP TRIGGERdrop trigger mytrig
2013/01/15 17:15:43DROP TABLEdrop table mycopy
002115TOMsqlplus.exeWORKGROUP\BLUECORE210
2013/01/15 17:17:26CREATE TABLEcreate table mycopy (salary number, first varchar2(50), last varchar2(50))
2013/01/15 17:17:54CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from employees e, salaries s where s.emp = e.id);
end;
2013/01/15 17:18:27CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select salary, first, last from employees,salaries where emp = id);
end;
2013/01/15 17:19:31ERRORalter mytrig compile debug
2013/01/15 17:19:40ALTER TRIGGERalter trigger mytrig compile debug
2013/01/15 17:23:12CREATE TRIGGERcreate or replace trigger mytrig after delete on mycopy
begin
  insert into mycopy (select s.salary, e.first, e.last from hrapp.employees e, hrapp.salaries s where s.emp = e.id);
end;
2013/01/15 17:23:39DROP TABLEdrop table mycopy
2013/01/15 17:23:46ERRORdrop trigger mytrig
2013/01/15 17:24:39ERRORdrop trigger mytrig
2013/01/15 17:24:53ERRORdrop trigger mytrig
002131HRAPPsqlplus.exeWORKGROUP\BLUECORE24
2013/01/15 17:33:26CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:33:36ERRORcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
          insert into mycopy values(:new.emp, :new.salary, :new.bonus);
end;
2013/01/15 17:33:57ERRORcreate or replace trigger salary_processing
after insert on salaries for each row
begin
          insert into mycopy values(:new.emp, :new.salary, :new.bonus);
end;
2013/01/15 17:36:15DROP TABLEdrop table mycopy
002144TOMsqlplus.exeWORKGROUP\BLUECORE24
2013/01/15 17:38:15CREATE TABLEcreate table mycopy (emp number, salary number, bonus number)
2013/01/15 17:38:15CREATE TRIGGERcreate or replace trigger salary_processing
after insert on hrapp.salaries for each row
begin
  insert into tom.mycopy values(:new.emp, :new.salary, :new.bonus);
end;
2013/01/15 17:39:15DROP TRIGGERdrop trigger salary_processing
2013/01/15 17:39:16DROP TABLEdrop table mycopy