Schema DDL detail by Session
From:
2013/01/15 04:00:00
To:
2013/01/16 04:00:00
AIX-11g
ORA11 on lpar26p682e_pub
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000159TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10024
2013/01/15 12:43:59CREATE USERcreate user dummy identified by                   
2013/01/15 12:43:59CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 12:44:00ALTER TABLEAlter table employee modify ( id number)
2013/01/15 12:44:00ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 12:44:03CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 12:44:03CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 12:44:17CREATE FUNCTIONCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 12:44:18CREATE FUNCTIONCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 12:44:18CREATE TYPECREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 12:44:19CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 12:44:23CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 12:44:25CREATE CLUSTERCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 12:44:25CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 12:44:25DROP MATERIALIZED VIEW LOGdrop materialized view log on tom.employee
2013/01/15 12:44:25DROP TABLEdrop table Employee
2013/01/15 12:44:26DROP MATERIALIZED VIEWdrop materialized view emp_sal
2013/01/15 12:44:26DROP TABLEdrop table ORAAUD_TEST
2013/01/15 12:44:26DROP TABLEdrop table x
2013/01/15 12:44:26DROP TABLEDROP TABLE varray_table
2013/01/15 12:44:27DROP TYPEDROP TYPE vcarray
2013/01/15 12:44:27DROP USERdrop user dummy
2013/01/15 12:44:30DROP CLUSTERdrop cluster personnel
2013/01/15 12:44:30DROP FUNCTIONdrop function fib
2013/01/15 12:44:30DROP FUNCTIONdrop function fac
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
000292TOMsqlplus.exeWORKGROUP\BLUECORE2172.29.149.10024
2013/01/15 17:47:11CREATE USERcreate user dummy identified by                   
2013/01/15 17:47:11CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 17:47:12ALTER TABLEAlter table employee modify ( id number)
2013/01/15 17:47:12ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 17:47:14CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 17:47:14CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 17:47:27CREATE FUNCTIONCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 17:47:28CREATE FUNCTIONCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 17:47:28CREATE TYPECREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 17:47:29CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 17:47:33CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 17:47:34CREATE CLUSTERCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 17:47:34CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 17:47:35DROP MATERIALIZED VIEW LOGdrop materialized view log on tom.employee
2013/01/15 17:47:35DROP TABLEdrop table Employee
2013/01/15 17:47:35DROP MATERIALIZED VIEWdrop materialized view emp_sal
2013/01/15 17:47:35DROP TABLEdrop table ORAAUD_TEST
2013/01/15 17:47:36DROP TABLEdrop table x
2013/01/15 17:47:36DROP TABLEDROP TABLE varray_table
2013/01/15 17:47:36DROP TYPEDROP TYPE vcarray
2013/01/15 17:47:37DROP USERdrop user dummy
2013/01/15 17:47:40DROP CLUSTERdrop cluster personnel
2013/01/15 17:47:41DROP FUNCTIONdrop function fib
2013/01/15 17:47:41DROP FUNCTIONdrop function fac
Linux32-10g
ORA10 on centos32
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000425TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10924
2013/01/15 12:54:26INTERNALcreate user dummy identified by                   
2013/01/15 12:54:27CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 12:54:28ALTER TABLEAlter table employee modify ( id number)
2013/01/15 12:54:29ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 12:54:34CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 12:54:36CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 12:54:46INTERNALCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 12:54:48INTERNALCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 12:54:48INTERNALCREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 12:54:51CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 12:54:53CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 12:54:54INTERNALCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 12:54:54CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 12:54:54INTERNALdrop materialized view log on tom.employee
2013/01/15 12:54:55INTERNALdrop table Employee
2013/01/15 12:54:55INTERNALdrop materialized view emp_sal
2013/01/15 12:54:56INTERNALdrop table ORAAUD_TEST
2013/01/15 12:54:56INTERNALdrop table x
2013/01/15 12:54:56INTERNALDROP TABLE varray_table
2013/01/15 12:54:56INTERNALDROP TYPE vcarray
2013/01/15 12:54:57INTERNALdrop user dummy
2013/01/15 12:55:05INTERNALdrop cluster personnel
2013/01/15 12:55:08INTERNALdrop function fib
2013/01/15 12:55:08INTERNALdrop function fac
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
000595TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10924
2013/01/15 17:50:13INTERNALcreate user dummy identified by                   
2013/01/15 17:50:13CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 17:50:14ALTER TABLEAlter table employee modify ( id number)
2013/01/15 17:50:14ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 17:50:15CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 17:50:16CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 17:50:23INTERNALCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 17:50:23INTERNALCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 17:50:23INTERNALCREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 17:50:24CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 17:50:25CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 17:50:25INTERNALCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 17:50:25CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 17:50:25INTERNALdrop materialized view log on tom.employee
2013/01/15 17:50:26INTERNALdrop table Employee
2013/01/15 17:50:26INTERNALdrop materialized view emp_sal
2013/01/15 17:50:26INTERNALdrop table ORAAUD_TEST
2013/01/15 17:50:27INTERNALdrop table x
2013/01/15 17:50:27INTERNALDROP TABLE varray_table
2013/01/15 17:50:27INTERNALDROP TYPE vcarray
2013/01/15 17:50:27INTERNALdrop user dummy
2013/01/15 17:50:46INTERNALdrop cluster personnel
2013/01/15 17:50:46INTERNALdrop function fib
2013/01/15 17:50:46INTERNALdrop function fac
Linux64-11g
ORA11 on centos64
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
000991TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10924
2013/01/15 13:02:24CREATE USERcreate user dummy identified by                   
2013/01/15 13:02:31CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 13:02:34ALTER TABLEAlter table employee modify ( id number)
2013/01/15 13:02:36ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 13:02:40CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 13:02:44CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 13:03:02CREATE FUNCTIONCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 13:03:05CREATE FUNCTIONCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 13:03:05CREATE TYPECREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 13:03:08CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 13:03:16CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 13:03:24CREATE CLUSTERCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 13:03:24CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 13:03:25DROP MATERIALIZED VIEW LOGdrop materialized view log on tom.employee
2013/01/15 13:03:32DROP TABLEdrop table Employee
2013/01/15 13:03:33DROP MATERIALIZED VIEWdrop materialized view emp_sal
2013/01/15 13:03:34DROP TABLEdrop table ORAAUD_TEST
2013/01/15 13:03:34DROP TABLEdrop table x
2013/01/15 13:03:34DROP TABLEDROP TABLE varray_table
2013/01/15 13:03:34DROP TYPEDROP TYPE vcarray
2013/01/15 13:03:36DROP USERdrop user dummy
2013/01/15 13:04:17DROP CLUSTERdrop cluster personnel
2013/01/15 13:04:18DROP FUNCTIONdrop function fib
2013/01/15 13:04:18DROP FUNCTIONdrop function fac
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
000464TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10924
2013/01/15 12:40:08INTERNALcreate user dummy identified by                   
2013/01/15 12:40:09CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 12:40:09ALTER TABLEAlter table employee modify ( id number)
2013/01/15 12:40:10ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 12:40:12CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 12:40:13CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 12:40:24INTERNALCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 12:40:24INTERNALCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 12:40:24INTERNALCREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 12:40:25CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 12:40:28CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 12:40:28INTERNALCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 12:40:28CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 12:40:29INTERNALdrop materialized view log on tom.employee
2013/01/15 12:40:32INTERNALdrop table Employee
2013/01/15 12:40:33INTERNALdrop materialized view emp_sal
2013/01/15 12:40:34INTERNALdrop table ORAAUD_TEST
2013/01/15 12:40:34INTERNALdrop table x
2013/01/15 12:40:34INTERNALDROP TABLE varray_table
2013/01/15 12:40:34INTERNALDROP TYPE vcarray
2013/01/15 12:40:35INTERNALdrop user dummy
2013/01/15 12:41:03INTERNALdrop cluster personnel
2013/01/15 12:41:05INTERNALdrop function fib
2013/01/15 12:41:06INTERNALdrop function fac
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
000894TOMsqlplus.exeWORKGROUP\BLUECORE2172.16.0.10924
2013/01/15 17:53:57INTERNALcreate user dummy identified by                   
2013/01/15 17:53:58CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 17:53:58ALTER TABLEAlter table employee modify ( id number)
2013/01/15 17:53:59ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 17:53:59CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 17:54:00CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 17:54:08INTERNALCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 17:54:09INTERNALCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 17:54:09INTERNALCREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 17:54:09CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 17:54:12CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 17:54:12INTERNALCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 17:54:12CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 17:54:13INTERNALdrop materialized view log on tom.employee
2013/01/15 17:54:15INTERNALdrop table Employee
2013/01/15 17:54:16INTERNALdrop materialized view emp_sal
2013/01/15 17:54:17INTERNALdrop table ORAAUD_TEST
2013/01/15 17:54:17INTERNALdrop table x
2013/01/15 17:54:17INTERNALDROP TABLE varray_table
2013/01/15 17:54:18INTERNALDROP TYPE vcarray
2013/01/15 17:54:18INTERNALdrop user dummy
2013/01/15 17:54:43INTERNALdrop cluster personnel
2013/01/15 17:54:46INTERNALdrop function fib
2013/01/15 17:54:47INTERNALdrop function fac
Windows-11g
ORA11 on bluecore2
SesKeyUsernameProgramMachineIPCount
SQL StartCommandSQL Text
001610TOMsqlplus.exeWORKGROUP\BLUECORE224
2013/01/15 12:16:23CREATE USERcreate user dummy identified by                   
2013/01/15 12:16:25CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 12:16:26ALTER TABLEAlter table employee modify ( id number)
2013/01/15 12:16:27ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 12:16:30CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 12:16:33CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 12:16:46CREATE FUNCTIONCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 12:16:48CREATE FUNCTIONCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 12:16:48CREATE TYPECREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 12:16:50CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 12:16:55CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 12:16:55CREATE CLUSTERCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 12:16:55CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 12:16:55DROP MATERIALIZED VIEW LOGdrop materialized view log on tom.employee
2013/01/15 12:16:59DROP TABLEdrop table Employee
2013/01/15 12:16:59DROP MATERIALIZED VIEWdrop materialized view emp_sal
2013/01/15 12:17:00DROP TABLEdrop table ORAAUD_TEST
2013/01/15 12:17:01DROP TABLEdrop table x
2013/01/15 12:17:01DROP TABLEDROP TABLE varray_table
2013/01/15 12:17:01DROP TYPEDROP TYPE vcarray
2013/01/15 12:17:02DROP USERdrop user dummy
2013/01/15 12:17:29DROP CLUSTERdrop cluster personnel
2013/01/15 12:17:30DROP FUNCTIONdrop function fib
2013/01/15 12:17:30DROP FUNCTIONdrop function fac
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
002163TOMsqlplus.exeWORKGROUP\BLUECORE224
2013/01/15 17:46:47CREATE USERcreate user dummy identified by                   
2013/01/15 17:46:47CREATE TABLEcreate table Employee(
    ID                 VARCHAR2(4)         NOT NULL,
    First_Name         VARCHAR2(10),
    Last_Name          VARCHAR2(10),
    Start_Date         DATE,
    End_Date           DATE,
    Salary             Number(8,2),
    City               VARCHAR2(10),
    Description        VARCHAR2(15)
  )
2013/01/15 17:46:48ALTER TABLEAlter table employee modify ( id number)
2013/01/15 17:46:48ALTER TABLEalter table employee add constraint employee_pk primary key (ID)
2013/01/15 17:46:49CREATE MATERIALIZED VIEW LOGcreate materialized view log on tom.employee including new values
2013/01/15 17:46:50CREATE MATERIALIZED VIEWcreate materialized view emp_sal
refresh fast on commit
enable query rewrite
as select id,first_name,start_date,salary,description from tom.employee
2013/01/15 17:46:55CREATE FUNCTIONCREATE OR REPLACE FUNCTION fac (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF n = 1 THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN n * fac(n - 1);  -- recursive call
  END IF;
END fac;
2013/01/15 17:46:57CREATE FUNCTIONCREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
  IF (n = 1) OR (n = 2) THEN  -- terminating condition
     RETURN 1;
  ELSE
     RETURN fib(n - 1) + fib(n - 2);  -- recursive call
  END IF;
END fib;
2013/01/15 17:46:57CREATE TYPECREATE OR REPLACE TYPE vcarray AS VARRAY(10) OF VARCHAR2(128);
2013/01/15 17:46:58CREATE TABLECREATE TABLE varray_table (id number, col1 vcarray)
2013/01/15 17:47:02CREATE TABLEcreate global temporary table x (a date)
        on commit delete rows     -- Delete rows after commit
        -- on commit preserve rows   -- Delete rows after exit session
2013/01/15 17:47:02CREATE CLUSTERCREATE CLUSTER personnel
   (department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K)
2013/01/15 17:47:03CREATE INDEXCREATE INDEX idx_personnel ON CLUSTER personnel
2013/01/15 17:47:03DROP MATERIALIZED VIEW LOGdrop materialized view log on tom.employee
2013/01/15 17:47:03DROP TABLEdrop table Employee
2013/01/15 17:47:04DROP MATERIALIZED VIEWdrop materialized view emp_sal
2013/01/15 17:47:04DROP TABLEdrop table ORAAUD_TEST
2013/01/15 17:47:05DROP TABLEdrop table x
2013/01/15 17:47:05DROP TABLEDROP TABLE varray_table
2013/01/15 17:47:05DROP TYPEDROP TYPE vcarray
2013/01/15 17:47:05DROP USERdrop user dummy
2013/01/15 17:47:31DROP CLUSTERdrop cluster personnel
2013/01/15 17:47:31DROP FUNCTIONdrop function fib
2013/01/15 17:47:31DROP FUNCTIONdrop function fac