conn local1/local1
SET FEEDBACK OFF
SET VERIFY OFF
SET SERVEROUTPUT ON
PROMPT als User local1 eingeloggt
PROMPT
ALTER SESSION SET nls_date_format = 'dd.mm.rr';
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE emp_local1';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

CREATE TABLE emp_local1
    ( employee_id    NUMBER(6)
    , first_name     VARCHAR2(20)
    , last_name      VARCHAR2(25)
    , email          VARCHAR2(25)
    , phone_number   VARCHAR2(20)
    , hire_date      DATE
    , job_id         VARCHAR2(10)
    , salary         NUMBER(8,2)
    , commission_pct NUMBER(2,2)
    , manager_id     NUMBER(6)
    , department_id  NUMBER(4)
    , CONSTRAINT emp1_emp_id_pk PRIMARY KEY (employee_id));

INSERT INTO emp_local1 VALUES(100,'Steven','King','Sking','515.123.4567','03.06.87','AD_PRES',25200,null,null,90);
INSERT INTO emp_local1 VALUES(101,'Neena','Kochhar','NKOCHHAR','515.123.4568','21.09.89','AD_VP',17000,null,100,90);
INSERT INTO emp_local1 VALUES(102,'Lex','De Haan','LDEHAAN','515.123.4569','13.01.93','AD_VP',17000,null,100,90);
INSERT INTO emp_local1 VALUES(103,'Alexander','Hunold','AHUNOLD','590.423.4567','03.01.90','IT_PROG',9000,null,102,60);
INSERT INTO emp_local1 VALUES(104,'Bruce','Ernst','Bernst','590.423.4568','07.05.91','IT_PROG',6300,null,103,60);
INSERT INTO emp_local1 VALUES(105,'David','Austin','DAUSTIN','590.423.4569','25.06.97','IT_PROG',4800,null,103,60);
INSERT INTO emp_local1 VALUES(106,'Valli','Pataballa','VPATABAL','590.423.4560','05.02.98','IT_PROG',4800,null,103,60);
INSERT INTO emp_local1 VALUES(107,'Diana','Lorentz','DLORENTZ','590.423.5567','07.02.99','IT_PROG',4200,null,103,60);
INSERT INTO emp_local1 VALUES(108,'Nancy','Greenberg','Ngreenbe','515.124.4569','03.08.94','FI_MGR',12600,null,101,100);
INSERT INTO emp_local1 VALUES(109,'Daniel','Faviet','DFAVIET','515.124.4169','16.08.94','FI_ACCOUNT',9000,null,108,100);
INSERT INTO emp_local1 VALUES(110,'John','Chen','JCHEN','515.124.4269','28.09.97','FI_ACCOUNT',8200,null,108,100);
INSERT INTO emp_local1 VALUES(112,'Jose Manuel','Urman','Jmurman','515.124.4469','21.02.98','FI_ACCOUNT',8190,null,108,100);
INSERT INTO emp_local1 VALUES(113,'Luis','Popp','LPOPP','515.124.4567','07.12.99','FI_ACCOUNT',6900,null,108,100);
INSERT INTO emp_local1 VALUES(114,'Den','Raphaely','DRAPHEAL','515.127.4561','07.12.94','PU_MAN',11000,null,100,30);
INSERT INTO emp_local1 VALUES(115,'Alexander','Khoo','AKHOO','515.127.4562','18.05.95','PU_CLERK',3100,null,114,30);
INSERT INTO emp_local1 VALUES(116,'Shelli','Baida','Sbaida','515.127.4563','10.12.97','PU_CLERK',3045,null,114,30);
INSERT INTO emp_local1 VALUES(117,'Sigal','Tobias','STOBIAS','515.127.4564','24.07.97','PU_CLERK',2800,null,114,30);
INSERT INTO emp_local1 VALUES(118,'Guy','Himuro','GHIMURO','515.127.4565','15.11.98','PU_CLERK',2600,null,114,30);
INSERT INTO emp_local1 VALUES(119,'Karen','Colmenares','KCOLMENA','515.127.4566','10.08.99','PU_CLERK',2500,null,114,30);
INSERT INTO emp_local1 VALUES(120,'Matthew','Weiss','Mweiss','650.123.1234','04.07.96','ST_MAN',8400,null,100,50);
INSERT INTO emp_local1 VALUES(121,'Adam','Fripp','AFRIPP','650.123.2234','10.04.97','ST_MAN',8200,null,100,50);
INSERT INTO emp_local1 VALUES(122,'Payam','Kaufling','PKAUFLIN','650.123.3234','01.05.95','ST_MAN',7900,null,100,50);
INSERT INTO emp_local1 VALUES(123,'Shanta','Vollman','SVOLLMAN','650.123.4234','10.10.97','ST_MAN',6500,null,100,50);
INSERT INTO emp_local1 VALUES(124,'Kevin','Mourgos','Kmourgos','650.123.5234','02.11.99','ST_MAN',6090,null,100,50);
INSERT INTO emp_local1 VALUES(125,'Julia','Nayer','JNAYER','650.124.1214','16.07.97','ST_CLERK',3200,null,120,50);
INSERT INTO emp_local1 VALUES(126,'Irene','Mikkilineni','IMIKKILI','650.124.1224','28.09.98','ST_CLERK',2700,null,120,50);
INSERT INTO emp_local1 VALUES(127,'James','Landry','JLANDRY','650.124.1334','14.01.99','ST_CLERK',2400,null,120,50);
INSERT INTO emp_local1 VALUES(128,'Steven','Markle','Smarkle','650.124.1434','23.02.00','ST_CLERK',2310,null,120,50);
INSERT INTO emp_local1 VALUES(129,'Laura','Bissot','LBISSOT','650.124.5234','20.08.97','ST_CLERK',3300,null,121,50);
INSERT INTO emp_local1 VALUES(130,'Mozhe','Atkinson','MATKINSO','650.124.6234','30.10.97','ST_CLERK',2800,null,121,50);
INSERT INTO emp_local1 VALUES(131,'James','Marlow','JAMRLOW','650.124.7234','16.02.97','ST_CLERK',2500,null,121,50);
INSERT INTO emp_local1 VALUES(132,'TJ','Olson','Tjolson','650.124.8234','27.03.99','ST_CLERK',2205,null,121,50);
INSERT INTO emp_local1 VALUES(134,'Michael','Rogers','MROGERS','650.127.1834','26.08.98','ST_CLERK',2900,null,122,50);
INSERT INTO emp_local1 VALUES(135,'Ki','Gee','KGEE','650.127.1734','12.12.99','ST_CLERK',2400,null,122,50);
INSERT INTO emp_local1 VALUES(136,'Hazel','Philtanker','Hphiltan','650.127.1634','23.01.00','ST_CLERK',2310,null,122,50);
INSERT INTO emp_local1 VALUES(137,'Renske','Ladwig','RLADWIG','650.121.1234','14.07.95','ST_CLERK',3600,null,123,50);
INSERT INTO emp_local1 VALUES(138,'Stephen','Stiles','SSTILES','650.121.2034','26.10.97','ST_CLERK',3200,null,123,50);
INSERT INTO emp_local1 VALUES(139,'John','Seo','JSEO','650.121.2019','12.02.98','ST_CLERK',2700,null,123,50);
INSERT INTO emp_local1 VALUES(140,'Joshua','Patel','Jpatel','650.121.1834','23.03.98','ST_CLERK',2625,null,123,50);
INSERT INTO emp_local1 VALUES(141,'Trenna','Rajs','TRAJS','650.121.8009','17.10.95','ST_CLERK',3500,null,124,50);
INSERT INTO emp_local1 VALUES(142,'Curtis','Davies','CDAVIES','650.121.2994','29.01.97','ST_CLERK',3100,null,124,50);
INSERT INTO emp_local1 VALUES(143,'Randall','Matos','RMATOS','650.121.2874','15.03.98','ST_CLERK',2600,null,124,50);
INSERT INTO emp_local1 VALUES(145,'John','Russell','JRUSSEL','011.44.1344.429268','01.10.96','SA_MAN',14000,0.4,100,80);
INSERT INTO emp_local1 VALUES(146,'Karen','Partners','KPARTNER','011.44.1344.467268','05.01.97','SA_MAN',13500,0.3,100,80);
INSERT INTO emp_local1 VALUES(147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278','10.03.97','SA_MAN',12000,0.3,100,80);
INSERT INTO emp_local1 VALUES(148,'Gerald','Cambrault','Gcambrau','011.44.1344.619268','01.10.99','SA_MAN',11550,0.45,100,80);
INSERT INTO emp_local1 VALUES(149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018','29.01.00','SA_MAN',10500,0.2,100,80);
INSERT INTO emp_local1 VALUES(151,'David','Bernstein','DBERNSTE','011.44.1344.345268','24.03.97','SA_REP',9500,0.25,145,80);
INSERT INTO emp_local1 VALUES(152,'Peter','Hall','Phall','011.44.1344.478968','06.08.97','SA_REP',9450,0.38,145,80);
INSERT INTO emp_local1 VALUES(153,'Christopher','Olsen','COLSEN','011.44.1344.498718','30.03.98','SA_REP',8000,0.2,145,80);
INSERT INTO emp_local1 VALUES(154,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668','09.12.98','SA_REP',7500,0.2,145,80);
INSERT INTO emp_local1 VALUES(156,'Janette','King','Jking','011.44.1345.429268','16.01.96','SA_REP',10500,0.53,146,80);
INSERT INTO emp_local1 VALUES(157,'Patrick','Sully','PSULLY','011.44.1345.929268','04.03.96','SA_REP',9500,0.35,146,80);
INSERT INTO emp_local1 VALUES(158,'Allan','McEwen','AMCEWEN','011.44.1345.829268','01.08.96','SA_REP',9000,0.35,146,80);
INSERT INTO emp_local1 VALUES(159,'Lindsey','Smith','LSMITH','011.44.1345.729268','10.03.97','SA_REP',8000,0.3,146,80);
INSERT INTO emp_local1 VALUES(160,'Louise','Doran','Ldoran','011.44.1345.629268','01.12.97','SA_REP',7875,0.45,146,80);
INSERT INTO emp_local1 VALUES(161,'Sarath','Sewall','SSEWALL','011.44.1345.529268','03.11.98','SA_REP',7000,0.25,146,80);
INSERT INTO emp_local1 VALUES(162,'Clara','Vishney','CVISHNEY','011.44.1346.129268','11.11.97','SA_REP',10500,0.25,147,80);
INSERT INTO emp_local1 VALUES(163,'Danielle','Greene','DGREENE','011.44.1346.229268','19.03.99','SA_REP',9500,0.15,147,80);
INSERT INTO emp_local1 VALUES(164,'Mattea','Marvins','Mmarvins','011.44.1346.329268','10.01.00','SA_REP',7560,0.15,147,80);
INSERT INTO emp_local1 VALUES(165,'David','Lee','DLEE','011.44.1346.529268','23.02.00','SA_REP',6800,0.1,147,80);
INSERT INTO emp_local1 VALUES(167,'Amit','Banda','ABANDA','011.44.1346.729268','21.04.00','SA_REP',6200,0.1,147,80);
INSERT INTO emp_local1 VALUES(168,'Lisa','Ozer','Lozer','011.44.1343.929268','25.02.97','SA_REP',12075,0.38,148,80);
INSERT INTO emp_local1 VALUES(169,'Harrison','Bloom','HBLOOM','011.44.1343.829268','23.03.98','SA_REP',10000,0.2,148,80);
INSERT INTO emp_local1 VALUES(170,'Tayler','Fox','TFOX','011.44.1343.729268','24.01.98','SA_REP',9600,0.2,148,80);
INSERT INTO emp_local1 VALUES(171,'William','Smith','WSMITH','011.44.1343.629268','23.02.99','SA_REP',7400,0.15,148,80);
INSERT INTO emp_local1 VALUES(172,'Elizabeth','Bates','Ebates','011.44.1343.529268','10.03.99','SA_REP',7665,0.23,148,80);
INSERT INTO emp_local1 VALUES(173,'Sundita','Kumar','SKUMAR','011.44.1343.329268','21.04.00','SA_REP',6100,0.1,148,80);
INSERT INTO emp_local1 VALUES(174,'Ellen','Abel','EABEL','011.44.1644.429267','11.05.96','SA_REP',11000,0.3,149,80);
INSERT INTO emp_local1 VALUES(175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266','19.03.97','SA_REP',8800,0.25,149,80);
INSERT INTO emp_local1 VALUES(176,'Jonathon','Taylor','Jtaylor','011.44.1644.429265','10.03.98','SA_REP',9030,0.3,149,80);
INSERT INTO emp_local1 VALUES(178,'Kimberely','Grant','KGRANT','011.44.1644.429263','24.05.99','SA_REP',7000,0.15,149,null);
INSERT INTO emp_local1 VALUES(179,'Charles','Johnson','CJOHNSON','011.44.1644.429262','04.01.00','SA_REP',6200,0.1,149,80);
INSERT INTO emp_local1 VALUES(180,'Winston','Taylor','Wtaylor','650.507.9876','10.01.98','SH_CLERK',3360,null,120,50);
INSERT INTO emp_local1 VALUES(181,'Jean','Fleaur','JFLEAUR','650.507.9877','23.02.98','SH_CLERK',3100,null,120,50);
INSERT INTO emp_local1 VALUES(182,'Martha','Sullivan','MSULLIVA','650.507.9878','21.06.99','SH_CLERK',2500,null,120,50);
INSERT INTO emp_local1 VALUES(183,'Girard','Geoni','GGEONI','650.507.9879','03.02.00','SH_CLERK',2800,null,120,50);
INSERT INTO emp_local1 VALUES(184,'Nandita','Sarchand','Nsarchan','650.509.1876','13.01.96','SH_CLERK',4410,null,121,50);
INSERT INTO emp_local1 VALUES(185,'Alexis','Bull','ABULL','650.509.2876','20.02.97','SH_CLERK',4100,null,121,50);
INSERT INTO emp_local1 VALUES(186,'Julia','Dellinger','JDELLING','650.509.3876','24.06.98','SH_CLERK',3400,null,121,50);
INSERT INTO emp_local1 VALUES(187,'Anthony','Cabrio','ACABRIO','650.509.4876','07.02.99','SH_CLERK',3000,null,121,50);
INSERT INTO emp_local1 VALUES(189,'Jennifer','Dilly','JDILLY','650.505.2876','13.08.97','SH_CLERK',3600,null,122,50);
INSERT INTO emp_local1 VALUES(190,'Timothy','Gates','TGATES','650.505.3876','11.07.98','SH_CLERK',2900,null,122,50);
INSERT INTO emp_local1 VALUES(191,'Randall','Perkins','RPERKINS','650.505.4876','19.12.99','SH_CLERK',2500,null,122,50);
INSERT INTO emp_local1 VALUES(192,'Sarah','Bell','Sbell','650.501.1876','21.01.96','SH_CLERK',4200,null,123,50);
INSERT INTO emp_local1 VALUES(193,'Britney','Everett','BEVERETT','650.501.2876','03.03.97','SH_CLERK',3900,null,123,50);
INSERT INTO emp_local1 VALUES(194,'Samuel','McCain','SMCCAIN','650.501.3876','01.07.98','SH_CLERK',3200,null,123,50);
INSERT INTO emp_local1 VALUES(195,'Vance','Jones','VJONES','650.501.4876','17.03.99','SH_CLERK',2800,null,123,50);
INSERT INTO emp_local1 VALUES(196,'Alana','Walsh','Awalsh','650.507.9811','10.04.98','SH_CLERK',3255,null,124,50);
INSERT INTO emp_local1 VALUES(197,'Kevin','Feeney','KFEENEY','650.507.9822','23.05.98','SH_CLERK',3000,null,124,50);
INSERT INTO emp_local1 VALUES(198,'Donald','OConnell','DOCONNEL','650.507.9833','21.06.99','SH_CLERK',2600,null,124,50);
INSERT INTO emp_local1 VALUES(200,'Jennifer','Whalen','Jwhalen','515.123.4444','03.09.87','AD_ASST',4620,null,101,10);
INSERT INTO emp_local1 VALUES(201,'Michael','Hartstein','MHARTSTE','515.123.5555','17.02.96','MK_MAN',13000,null,100,20);
INSERT INTO emp_local1 VALUES(203,'Susan','Mavris','SMAVRIS','515.123.7777','07.06.94','HR_REP',6500,null,101,40);
INSERT INTO emp_local1 VALUES(204,'Hermann','Baer','Hbaer','515.123.8888','24.05.94','PR_REP',10500,null,101,70);
INSERT INTO emp_local1 VALUES(205,'Shelley','Higgins','SHIGGINS','515.123.8080','07.06.94','AC_MGR',12000,null,101,110);
INSERT INTO emp_local1 VALUES(206,'William','Gietz','WGIETZ','515.123.8181','07.06.94','AC_ACCOUNT',8300,null,205,110);
INSERT INTO emp_local1 VALUES(390,'Rainer','Mueller','RMUELLER','651.205.3876','11.07.11','SH_CLERK',3903,null,122,50);
INSERT INTO emp_local1 VALUES(391,'Susi','Sorglos','SSORGLOS','651.205.4876','19.12.06','SH_CLERK',3503,null,122,50);
INSERT INTO emp_local1 VALUES(392,'Sarah','Metzger','Smetzger','651.201.1876','21.01.08','SH_CLERK',5253,null,123,50);
INSERT INTO emp_local1 VALUES(393,'Britney','Spears','BSPEARS','651.201.2876','03.03.97','SH_CLERK',3903,null,123,50);
INSERT INTO emp_local1 VALUES(307,'Sam','Spade','SSPADE','651.201.3876','01.07.11','SH_CLERK',3203,null,123,50);
INSERT INTO emp_local1 VALUES(395,'Vincent','van Gogh','VVANGOGH','651.201.4876','17.03.06','SH_CLERK',3803,null,123,50);
INSERT INTO emp_local1 VALUES(396,'Anna','Lang','Alang','651.207.9811','10.04.11','SH_CLERK',3258,null,124,50);
INSERT INTO emp_local1 VALUES(397,'Kevin','Mueller','KMUELLER','651.207.9822','23.10.11','SH_CLERK',3003,null,124,50);
INSERT INTO emp_local1 VALUES(398,'Detlev','Maurer','DMAURER','651.207.9833','21.06.06','SH_CLERK',3603,null,124,50);
INSERT INTO emp_local1 VALUES(399,'Donald','Duck','DDUCK','651.207.9844','13.01.00','SH_CLERK',3603,null,124,50);
INSERT INTO emp_local1 VALUES(300,'Juliane','Zimmer','Jzimmer','515.123.4444','03.09.00','AD_ASST',5673,null,101,10);
INSERT INTO emp_local1 VALUES(301,'Michael','Fox','MFOX','515.123.5555','17.02.08','MK_MAN',13003,null,103,30);
INSERT INTO emp_local1 VALUES(302,'Paul','McCartney','PMCCARTNEY','603.123.6666','17.08.97','MK_REP',6003,null,301,30);
INSERT INTO emp_local1 VALUES(303,'Centa','Berger','SBERGER','515.122.8777','07.06.07','HR_REP',6503,null,101,50);
INSERT INTO emp_local1 VALUES(304,'Hermann','Maier','Hmaier','515.123.8888','24.05.07','PR_REP',10503,null,101,70);
INSERT INTO emp_local1 VALUES(305,'Sabine','Sauer','SSAUER','515.123.8080','07.06.07','AC_MGR',12003,null,101,110);
INSERT INTO emp_local1 VALUES(306,'Wilhelm','Tell','WTELL','515.123.8181','07.06.07','AC_ACCOUNT',8303,null,305,110);

PROMPT Tabelle emp_local1 im Schema local1 angelegt (fuer Vergleichstest im selben Schema)

-- Grant fuer den Vergleich zwischen verschiedenen Schemata
GRANT ALL ON emp_local1 TO local2;
PROMPT Rechte an emp_local1 an den User local2 vergeben
PROMPT
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE emp_local2';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

CREATE TABLE emp_local2(
      employee_id    NUMBER(6)
    , first_name     VARCHAR2(20)
    , last_name      VARCHAR2(25)
    , email          VARCHAR2(25)
    , phone_number   VARCHAR2(20)
    , hire_date      DATE
    , job_id         VARCHAR2(10)
    , salary         NUMBER(8,2)
    , commission_pct NUMBER(2,2)
    , manager_id     NUMBER(6)
    , department_id  NUMBER(4)
    , CONSTRAINT empr_emp_id_pk PRIMARY KEY (employee_id));

INSERT INTO emp_local2 VALUES(100,'Steven','King','Sking','515.123.4567','24.06.87','AD_PRES',22800,null,null,90);
INSERT INTO emp_local2 VALUES(101,'Neena','Kochhar','NKOCHHAR','515.123.4568','21.09.89','AD_VP',17000,null,100,90);
INSERT INTO emp_local2 VALUES(102,'Lex','De Haan','LDEHAAN','515.123.4569','13.01.93','AD_VP',17000,null,100,90);
INSERT INTO emp_local2 VALUES(103,'Alexander','Hunold','AHUNOLD','590.423.4567','03.01.90','IT_PROG',9000,null,102,60);
INSERT INTO emp_local2 VALUES(104,'Bruce','Ernst','Bernst','590.423.4568','28.05.91','IT_PROG',5700,null,103,60);
INSERT INTO emp_local2 VALUES(105,'David','Austin','DAUSTIN','590.423.4569','25.06.97','IT_PROG',4800,null,103,60);
INSERT INTO emp_local2 VALUES(106,'Valli','Pataballa','VPATABAL','590.423.4560','05.02.98','IT_PROG',4800,null,103,60);
INSERT INTO emp_local2 VALUES(107,'Diana','Lorentz','DLORENTZ','590.423.5567','07.02.99','IT_PROG',4200,null,103,60);
INSERT INTO emp_local2 VALUES(108,'Nancy','Greenberg','Ngreenbe','515.124.4569','24.08.94','FI_MGR',11400,null,101,100);
INSERT INTO emp_local2 VALUES(109,'Daniel','Faviet','DFAVIET','515.124.4169','16.08.94','FI_ACCOUNT',9000,null,108,100);
INSERT INTO emp_local2 VALUES(110,'John','Chen','JCHEN','515.124.4269','28.09.97','FI_ACCOUNT',8200,null,108,100);
INSERT INTO emp_local2 VALUES(111,'Ismael','Sciarra','ISCIARRA','515.124.4369','30.09.97','FI_ACCOUNT',7700,null,108,100);
INSERT INTO emp_local2 VALUES(113,'Luis','Popp','LPOPP','515.124.4567','07.12.99','FI_ACCOUNT',6900,null,108,100);
INSERT INTO emp_local2 VALUES(114,'Den','Raphaely','DRAPHEAL','515.127.4561','07.12.94','PU_MAN',11000,null,100,30);
INSERT INTO emp_local2 VALUES(115,'Alexander','Khoo','AKHOO','515.127.4562','18.05.95','PU_CLERK',3100,null,114,30);
INSERT INTO emp_local2 VALUES(116,'Shelli','Baida','Sbaida','515.127.4563','31.12.97','PU_CLERK',2755,null,114,30);
INSERT INTO emp_local2 VALUES(117,'Sigal','Tobias','STOBIAS','515.127.4564','24.07.97','PU_CLERK',2800,null,114,30);
INSERT INTO emp_local2 VALUES(118,'Guy','Himuro','GHIMURO','515.127.4565','15.11.98','PU_CLERK',2600,null,114,30);
INSERT INTO emp_local2 VALUES(119,'Karen','Colmenares','KCOLMENA','515.127.4566','10.08.99','PU_CLERK',2500,null,114,30);
INSERT INTO emp_local2 VALUES(120,'Matthew','Weiss','Mweiss','650.123.1234','25.07.96','ST_MAN',7600,null,100,50);
INSERT INTO emp_local2 VALUES(121,'Adam','Fripp','AFRIPP','650.123.2234','10.04.97','ST_MAN',8200,null,100,50);
INSERT INTO emp_local2 VALUES(122,'Payam','Kaufling','PKAUFLIN','650.123.3234','01.05.95','ST_MAN',7900,null,100,50);
INSERT INTO emp_local2 VALUES(123,'Shanta','Vollman','SVOLLMAN','650.123.4234','10.10.97','ST_MAN',6500,null,100,50);
INSERT INTO emp_local2 VALUES(124,'Kevin','Mourgos','Kmourgos','650.123.5234','23.11.99','ST_MAN',5510,null,100,50);
INSERT INTO emp_local2 VALUES(125,'Julia','Nayer','JNAYER','650.124.1214','16.07.97','ST_CLERK',3200,null,120,50);
INSERT INTO emp_local2 VALUES(126,'Irene','Mikkilineni','IMIKKILI','650.124.1224','28.09.98','ST_CLERK',2700,null,120,50);
INSERT INTO emp_local2 VALUES(127,'James','Landry','JLANDRY','650.124.1334','14.01.99','ST_CLERK',2400,null,120,50);
INSERT INTO emp_local2 VALUES(128,'Steven','Markle','Smarkle','650.124.1434','15.03.00','ST_CLERK',2090,null,120,50);
INSERT INTO emp_local2 VALUES(129,'Laura','Bissot','LBISSOT','650.124.5234','20.08.97','ST_CLERK',3300,null,121,50);
INSERT INTO emp_local2 VALUES(130,'Mozhe','Atkinson','MATKINSO','650.124.6234','30.10.97','ST_CLERK',2800,null,121,50);
INSERT INTO emp_local2 VALUES(131,'James','Marlow','JAMRLOW','650.124.7234','16.02.97','ST_CLERK',2500,null,121,50);
INSERT INTO emp_local2 VALUES(133,'Jason','Mallin','JMALLIN','650.127.1934','14.06.96','ST_CLERK',3300,null,122,50);
INSERT INTO emp_local2 VALUES(134,'Michael','Rogers','MROGERS','650.127.1834','26.08.98','ST_CLERK',2900,null,122,50);
INSERT INTO emp_local2 VALUES(135,'Ki','Gee','KGEE','650.127.1734','12.12.99','ST_CLERK',2400,null,122,50);
INSERT INTO emp_local2 VALUES(136,'Hazel','Philtanker','Hphiltan','650.127.1634','13.02.00','ST_CLERK',2090,null,122,50);
INSERT INTO emp_local2 VALUES(137,'Renske','Ladwig','RLADWIG','650.121.1234','14.07.95','ST_CLERK',3600,null,123,50);
INSERT INTO emp_local2 VALUES(138,'Stephen','Stiles','SSTILES','650.121.2034','26.10.97','ST_CLERK',3200,null,123,50);
INSERT INTO emp_local2 VALUES(139,'John','Seo','JSEO','650.121.2019','12.02.98','ST_CLERK',2700,null,123,50);
INSERT INTO emp_local2 VALUES(140,'Joshua','Patel','Jpatel','650.121.1834','13.04.98','ST_CLERK',2375,null,123,50);
INSERT INTO emp_local2 VALUES(141,'Trenna','Rajs','TRAJS','650.121.8009','17.10.95','ST_CLERK',3500,null,124,50);
INSERT INTO emp_local2 VALUES(142,'Curtis','Davies','CDAVIES','650.121.2994','29.01.97','ST_CLERK',3100,null,124,50);
INSERT INTO emp_local2 VALUES(144,'Peter','Vargas','Pvargas','650.121.2004','16.07.98','ST_CLERK',2375,null,124,50);
INSERT INTO emp_local2 VALUES(145,'John','Russell','JRUSSEL','011.44.1344.429268','01.10.96','SA_MAN',14000,0.4,100,80);
INSERT INTO emp_local2 VALUES(146,'Karen','Partners','KPARTNER','011.44.1344.467268','05.01.97','SA_MAN',13500,0.3,100,80);
INSERT INTO emp_local2 VALUES(147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278','10.03.97','SA_MAN',12000,0.3,100,80);
INSERT INTO emp_local2 VALUES(148,'Gerald','Cambrault','Gcambrau','011.44.1344.619268','22.10.99','SA_MAN',10450,0.36,100,80);
INSERT INTO emp_local2 VALUES(149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018','29.01.00','SA_MAN',10500,0.2,100,80);
INSERT INTO emp_local2 VALUES(150,'Peter','Tucker','PTUCKER','011.44.1344.129268','30.01.97','SA_REP',10000,0.3,145,80);
INSERT INTO emp_local2 VALUES(152,'Peter','Hall','Phall','011.44.1344.478968','27.08.97','SA_REP',8550,0.3,145,80);
INSERT INTO emp_local2 VALUES(153,'Christopher','Olsen','COLSEN','011.44.1344.498718','30.03.98','SA_REP',8000,0.2,145,80);
INSERT INTO emp_local2 VALUES(155,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508','23.11.99','SA_REP',7000,0.15,145,80);
INSERT INTO emp_local2 VALUES(156,'Janette','King','Jking','011.44.1345.429268','06.02.96','SA_REP',9500,0.42,146,80);
INSERT INTO emp_local2 VALUES(157,'Patrick','Sully','PSULLY','011.44.1345.929268','04.03.96','SA_REP',9500,0.35,146,80);
INSERT INTO emp_local2 VALUES(158,'Allan','McEwen','AMCEWEN','011.44.1345.829268','01.08.96','SA_REP',9000,0.35,146,80);
INSERT INTO emp_local2 VALUES(159,'Lindsey','Smith','LSMITH','011.44.1345.729268','10.03.97','SA_REP',8000,0.3,146,80);
INSERT INTO emp_local2 VALUES(160,'Louise','Doran','Ldoran','011.44.1345.629268','22.12.97','SA_REP',7125,0.36,146,80);
INSERT INTO emp_local2 VALUES(161,'Sarath','Sewall','SSEWALL','011.44.1345.529268','03.11.98','SA_REP',7000,0.25,146,80);
INSERT INTO emp_local2 VALUES(162,'Clara','Vishney','CVISHNEY','011.44.1346.129268','11.11.97','SA_REP',10500,0.25,147,80);
INSERT INTO emp_local2 VALUES(163,'Danielle','Greene','DGREENE','011.44.1346.229268','19.03.99','SA_REP',9500,0.15,147,80);
INSERT INTO emp_local2 VALUES(164,'Mattea','Marvins','Mmarvins','011.44.1346.329268','31.01.00','SA_REP',6840,0.12,147,80);
INSERT INTO emp_local2 VALUES(166,'Sundar','Ande','SANDE','011.44.1346.629268','24.03.00','SA_REP',6400,0.1,147,80);
INSERT INTO emp_local2 VALUES(167,'Amit','Banda','ABANDA','011.44.1346.729268','21.04.00','SA_REP',6200,0.1,147,80);
INSERT INTO emp_local2 VALUES(168,'Lisa','Ozer','Lozer','011.44.1343.929268','18.03.97','SA_REP',10925,0.3,148,80);
INSERT INTO emp_local2 VALUES(169,'Harrison','Bloom','HBLOOM','011.44.1343.829268','23.03.98','SA_REP',10000,0.2,148,80);
INSERT INTO emp_local2 VALUES(170,'Tayler','Fox','TFOX','011.44.1343.729268','24.01.98','SA_REP',9600,0.2,148,80);
INSERT INTO emp_local2 VALUES(171,'William','Smith','WSMITH','011.44.1343.629268','23.02.99','SA_REP',7400,0.15,148,80);
INSERT INTO emp_local2 VALUES(172,'Elizabeth','Bates','Ebates','011.44.1343.529268','31.03.99','SA_REP',6935,0.18,148,80);
INSERT INTO emp_local2 VALUES(173,'Sundita','Kumar','SKUMAR','011.44.1343.329268','21.04.00','SA_REP',6100,0.1,148,80);
INSERT INTO emp_local2 VALUES(174,'Ellen','Abel','EABEL','011.44.1644.429267','11.05.96','SA_REP',11000,0.3,149,80);
INSERT INTO emp_local2 VALUES(175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266','19.03.97','SA_REP',8800,0.25,149,80);
INSERT INTO emp_local2 VALUES(177,'Jack','Livingston','JLIVINGS','011.44.1644.429264','23.04.98','SA_REP',8400,0.2,149,80);
INSERT INTO emp_local2 VALUES(178,'Kimberely','Grant','KGRANT','011.44.1644.429263','24.05.99','SA_REP',7000,0.15,149,null);
INSERT INTO emp_local2 VALUES(179,'Charles','Johnson','CJOHNSON','011.44.1644.429262','04.01.00','SA_REP',6200,0.1,149,80);
INSERT INTO emp_local2 VALUES(180,'Winston','Taylor','Wtaylor','650.507.9876','31.01.98','SH_CLERK',3040,null,120,50);
INSERT INTO emp_local2 VALUES(181,'Jean','Fleaur','JFLEAUR','650.507.9877','23.02.98','SH_CLERK',3100,null,120,50);
INSERT INTO emp_local2 VALUES(182,'Martha','Sullivan','MSULLIVA','650.507.9878','21.06.99','SH_CLERK',2500,null,120,50);
INSERT INTO emp_local2 VALUES(183,'Girard','Geoni','GGEONI','650.507.9879','03.02.00','SH_CLERK',2800,null,120,50);
INSERT INTO emp_local2 VALUES(184,'Nandita','Sarchand','Nsarchan','650.509.1876','03.02.96','SH_CLERK',3990,null,121,50);
INSERT INTO emp_local2 VALUES(185,'Alexis','Bull','ABULL','650.509.2876','20.02.97','SH_CLERK',4100,null,121,50);
INSERT INTO emp_local2 VALUES(187,'Anthony','Cabrio','ACABRIO','650.509.4876','07.02.99','SH_CLERK',3000,null,121,50);
INSERT INTO emp_local2 VALUES(188,'Kelly','Chung','Kchung','650.505.1876','21.06.97','SH_CLERK',3610,null,122,50);
INSERT INTO emp_local2 VALUES(189,'Jennifer','Dilly','JDILLY','650.505.2876','13.08.97','SH_CLERK',3600,null,122,50);
INSERT INTO emp_local2 VALUES(190,'Timothy','Gates','TGATES','650.505.3876','11.07.98','SH_CLERK',2900,null,122,50);
INSERT INTO emp_local2 VALUES(191,'Randall','Perkins','RPERKINS','650.505.4876','19.12.99','SH_CLERK',2500,null,122,50);
INSERT INTO emp_local2 VALUES(192,'Sarah','Bell','Sbell','650.501.1876','11.02.96','SH_CLERK',3800,null,123,50);
INSERT INTO emp_local2 VALUES(193,'Britney','Everett','BEVERETT','650.501.2876','03.03.97','SH_CLERK',3900,null,123,50);
INSERT INTO emp_local2 VALUES(194,'Samuel','McCain','SMCCAIN','650.501.3876','01.07.98','SH_CLERK',3200,null,123,50);
INSERT INTO emp_local2 VALUES(195,'Vance','Jones','VJONES','650.501.4876','17.03.99','SH_CLERK',2800,null,123,50);
INSERT INTO emp_local2 VALUES(196,'Alana','Walsh','Awalsh','650.507.9811','01.05.98','SH_CLERK',2945,null,124,50);
INSERT INTO emp_local2 VALUES(197,'Kevin','Feeney','KFEENEY','650.507.9822','23.05.98','SH_CLERK',3000,null,124,50);
INSERT INTO emp_local2 VALUES(199,'Douglas','Grant','DGRANT','650.507.9844','13.01.00','SH_CLERK',2600,null,124,50);
INSERT INTO emp_local2 VALUES(200,'Jennifer','Whalen','Jwhalen','515.123.4444','24.09.87','AD_ASST',4180,null,101,10);
INSERT INTO emp_local2 VALUES(201,'Michael','Hartstein','MHARTSTE','515.123.5555','17.02.96','MK_MAN',13000,null,100,20);
INSERT INTO emp_local2 VALUES(202,'Pat','Fay','PFAY','603.123.6666','17.08.97','MK_REP',6000,null,201,20);
INSERT INTO emp_local2 VALUES(203,'Susan','Mavris','SMAVRIS','515.123.7777','07.06.94','HR_REP',6500,null,101,40);
INSERT INTO emp_local2 VALUES(205,'Shelley','Higgins','SHIGGINS','515.123.8080','07.06.94','AC_MGR',12000,null,101,110);
INSERT INTO emp_local2 VALUES(490,'Albert','Einstein','AEINSTEIN','651.205.3876','11.07.11','SH_CLERK',3903,null,122,50);
INSERT INTO emp_local2 VALUES(491,'Edward','Teller','ETELLER','651.205.4876','19.12.06','SH_CLERK',3503,null,122,50);
INSERT INTO emp_local2 VALUES(492,'Justus','Liebig','Jliebig','651.201.1876','11.02.08','SH_CLERK',4752.85,null,123,50);
INSERT INTO emp_local2 VALUES(493,'Otto','Fischer','OFISCHER','651.201.2876','03.03.97','SH_CLERK',3903,null,123,50);
INSERT INTO emp_local2 VALUES(407,'Wilhelm','Busch','WBUSCH','651.201.3876','01.07.11','SH_CLERK',3203,null,123,50);
INSERT INTO emp_local2 VALUES(495,'Klaus','Mann','KMANN','651.201.4876','17.03.06','SH_CLERK',3803,null,123,50);
INSERT INTO emp_local2 VALUES(496,'Henry','James','Hjames','651.207.9811','01.05.11','SH_CLERK',2947.85,null,124,50);
INSERT INTO emp_local2 VALUES(497,'Oswald','von Wolkenstein','OVWOLKENSTEIN','651.207.9822','23.10.11','SH_CLERK',3003,null,124,50);
INSERT INTO emp_local2 VALUES(498,'Walter','von der Vogelweide','WVDVOGELWEIDE','651.207.9833','21.06.06','SH_CLERK',3603,null,124,50);
INSERT INTO emp_local2 VALUES(499,'Hannah','Ahrends','HAHRENDS','651.207.9844','13.01.00','SH_CLERK',3603,null,124,50);
INSERT INTO emp_local2 VALUES(400,'Hildegard','von Bingen','Hvbingen','515.123.4444','24.09.00','AD_ASST',5132.85,null,101,10);
INSERT INTO emp_local2 VALUES(401,'Johanna','die Wahnsinnige','JWAHNSINN','515.123.5555','17.02.08','MK_MAN',13003,null,103,30);
INSERT INTO emp_local2 VALUES(402,'Karl','der Kahle','KDKAHLE','603.123.6666','17.08.97','MK_REP',6003,null,196,30);
INSERT INTO emp_local2 VALUES(403,'Philipp','der Gute','PDGUTE','515.122.8777','07.06.07','HR_REP',6503,null,101,50);
INSERT INTO emp_local2 VALUES(404,'Hartmann','von Aue','Hvaue','515.123.8888','14.06.07','PR_REP',9502.85,null,101,70);
INSERT INTO emp_local2 VALUES(405,'Daisy','Duck','DADUCK','515.123.8080','07.06.07','AC_MGR',12003,null,101,110);
INSERT INTO emp_local2 VALUES(406,'Oskar','Werner','OWERNER','515.123.8181','07.06.07','AC_ACCOUNT',8303,null,490,110);

PROMPT Tabelle emp_local2 im Schema local1 angelegt (fuer Vergleichstest im selben Schema)
GRANT ALL ON emp_local2 TO local2;
PROMPT Rechte an local1.emp_local2 an den User local2 vergeben
PROMPT
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE big_tab1';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

CREATE TABLE big_tab1 AS 
SELECT ROWNUM id, owner,object_name,subobject_name,object_id,data_object_id,object_type,created,last_ddl_time,timestamp,status,temporary,generated,secondary
FROM all_objects a WHERE 1=0;

DECLARE
  l_cnt  NUMBER;
  l_rows NUMBER := 2000000;
BEGIN
  INSERT /*+ APPEND */ INTO big_tab1 
  SELECT ROWNUM, owner,object_name,subobject_name,object_id,data_object_id,object_type,created,last_ddl_time,timestamp,status,temporary,generated,secondary
  FROM all_objects;
  l_cnt := SQL%ROWCOUNT;
  COMMIT;
  WHILE l_cnt < l_rows LOOP
    INSERT /*+ APPEND */ INTO big_tab1 
    SELECT ROWNUM + l_cnt, owner,object_name,subobject_name,object_id,data_object_id,object_type,created,last_ddl_time,timestamp,status,temporary,generated,secondary
    FROM big_tab1
    WHERE  ROWNUM <= l_rows - l_cnt;
    l_cnt  := l_cnt + SQL%ROWCOUNT;
  COMMIT;
  END LOOP;
END;
/

PROMPT Tabelle big_tab1 erstellt (fuer Laufzeitvergleiche im selben Schema)
PROMPT

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE big_tab2';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

CREATE TABLE big_tab2 AS SELECT * FROM big_tab1;
PROMPT  Tabelle big_tab2 erstellt (fuer Laufzeitvergleiche im selben Schema)
PROMPT  Aenderungen in big_tab2 einbauen:
BEGIN
  UPDATE big_tab2  SET object_name = 'X', object_type = 'Z', last_ddl_time = sysdate-14  
  WHERE MOD(object_id, 4000) = 0; 
  DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||' Zeilen aktualisiert');
  DELETE FROM big_tab2 WHERE MOD(object_id, 3999) = 0; 
  DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||' Zeilen geloescht');
  FOR i IN 1..100 LOOP
    INSERT INTO big_tab2(id, owner, object_id, object_name, created, last_ddl_time) 
    VALUES (4000000+i, user, 90002, 'Lang', sysdate, sysdate-i/1440); 
    INSERT INTO big_tab2(id, owner, object_id, object_name, created, last_ddl_time) 
    VALUES (5000001+i, user, 90003, 'Kurz', sysdate, sysdate-i/24);
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('200 Zeilen wurden eingefuegt');
  DBMS_OUTPUT.PUT_LINE(CHR(10));
END;
/
ALTER TABLE big_tab2 ADD CONSTRAINT big_tab2_pk PRIMARY KEY(id);

PROMPT
PROMPT  Aenderungen in big_tab1 einbauen:
BEGIN
  UPDATE big_tab1 SET object_name = 'A', object_type = 'B', last_ddl_time = sysdate  
  WHERE MOD(object_id, 5000) = 0; 
  DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||' Zeilen aktualisiert');
  DELETE FROM big_tab1 WHERE MOD(object_id, 4999) = 0; 
  DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||' Zeilen geloescht');
  FOR i IN 1..100 LOOP
    INSERT INTO big_tab1 (id, owner, object_id, object_name, created, last_ddl_time) 
    VALUES (2000000+i, user, 90000, 'Mueller', sysdate, sysdate-i/1440); 
    INSERT INTO big_tab1 (id, owner, object_id, object_name, created, last_ddl_time) 
    VALUES (3000000+i, user, 90001, 'Maier', sysdate, sysdate-i/24); 
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('200 Zeilen wurden eingefuegt');
  DBMS_OUTPUT.PUT_LINE(CHR(10));
END;
/
ALTER TABLE big_tab1 ADD CONSTRAINT big_tab1_pk PRIMARY KEY(id);

GRANT ALL ON big_tab2 TO local2;
PROMPT  Rechte an der Vergleichstabelle big_tab2 an local2 vergeben
PROMPT

BEGIN
  DBMS_STATS.GATHER_SCHEMA_STATS(
             ownname => 'LOCAL1', 
    estimate_percent => 50,
             cascade => TRUE);
END;
/

PROMPT  Statistiken fuer Schema local1 erstellt

BEGIN
  EXECUTE IMMEDIATE 'DROP DATABASE LINK remote_link';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

PROMPT  Datenbank-Link vom Schema local1 auf der lokalen DB zum Schema remote auf dem remote-Server wird erstellt
ACCEPT tns_alias_remote CHAR PROMPT  ' Geben Sie den TNS-Alias fuer die Verbindung zur remote-DB an:    '
CREATE DATABASE LINK remote_link CONNECT TO remote IDENTIFIED BY "remote" USING '&tns_alias_remote';
PROMPT

conn local2/local2
set feedback off
SET SERVEROUTPUT ON
PROMPT  als User local2 auf der lokalen DB eingeloggt
PROMPT

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE emp_local2';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

CREATE TABLE emp_local2 AS SELECT * FROM local1.emp_local2;
ALTER TABLE emp_local2 ADD CONSTRAINT emp_local2_pk PRIMARY KEY (employee_id);
PROMPT  Tabelle emp_local2 im Schema local2 angelegt (fuer Vergleichstest zwischen verschiedenen Schemata)
PROMPT

GRANT ALL ON emp_local2 TO local1;
PROMPT  Rechte an der Tabelle local2.emp_local2 an local1 vergeben
PROMPT

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE big_tab2';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/


CREATE TABLE big_tab2 AS SELECT * FROM local1.big_tab2;
ALTER TABLE big_tab2 ADD CONSTRAINT big_tab2_pk PRIMARY KEY(id);
PROMPT  Tabelle big_tab2 im Schema local2 erstellt (fuer Laufzeitvergleiche zwischen verschiedenen Schemata)
PROMPT

GRANT ALL ON big_tab2 TO local1;
PROMPT  Rechte an der Vergleichstabelle local2.big_tab2 an local1 vergeben
PROMPT
BEGIN
  DBMS_STATS.GATHER_SCHEMA_STATS(
             ownname => 'LOCAL2',
    estimate_percent => 50,
             cascade => TRUE);
END;
/

PROMPT  Statistiken fuer Schema local2 erfasst
PROMPT

ACCEPT host_name CHAR  PROMPT  ' Hostname oder IP-Adresse des remote-Servers angeben:    '
ACCEPT remote_sid CHAR PROMPT  ' SID des remote-Servers angeben:    '
PROMPT
conn remote/remote@&&host_name/&&remote_sid
set feedback off
SET SERVEROUTPUT ON
PROMPT  als User remote auf der remote-DB eingeloggt
EXEC DBMS_OUTPUT.PUT_LINE(SYS_CONTEXT('USERENV','SERVER_HOST')||', '||SYS_CONTEXT('USERENV','INSTANCE_NAME'));

BEGIN
  EXECUTE IMMEDIATE 'DROP DATABASE LINK local_link';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/

PROMPT  Datenbank-Link vom Schema remote auf dem remote-Server zum Schema local1 auf der lokalen DB wird erstellt
ACCEPT tns_alias_local1 CHAR PROMPT ' Geben Sie den TNS-Alias fuer die Verbindung von der remote-DB zur lokalen DB an:    '
CREATE DATABASE LINK local_link CONNECT TO local1 IDENTIFIED BY "local1" USING '&tns_alias_local1';
PROMPT
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE emp_remote';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/
CREATE TABLE emp_remote AS SELECT * FROM emp_local2@local_link;
ALTER TABLE emp_remote ADD CONSTRAINT empr_remote_pk PRIMARY KEY (employee_id);
PROMPT  Tabelle emp_remote im Schema remote auf der remote-DB erstellt (fuer Vergleichstests zwischen verschiedenen Datenbanken)
PROMPT

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE big_tab2';
EXCEPTION
  WHEN OTHERS THEN NULL;
END;
/
CREATE TABLE big_tab2 AS SELECT * FROM big_tab2@local_link;
ALTER TABLE big_tab2 ADD CONSTRAINT big_tab2_pk PRIMARY KEY(id);
PROMPT  Tabelle big_tab2 im Schema remote erstellt (fuer Laufzeittest zwischen verschiedenen Datenbanken)
PROMPT

BEGIN
  DBMS_STATS.GATHER_SCHEMA_STATS(
           ownname   => 'REMOTE', 
    estimate_percent => 50,
             cascade => TRUE);
END;
/
PROMPT  Statistiken fuer Schema remote auf der remote-DB erfasst
PROMPT 
conn local1/local1
PROMPT  als User local1 eingeloggt
PROMPT  Erstellen Sie die Packages fuer Vergleich_10g und Vergleich_11g als user local1
PROMPT  mit den Skripten Vergleich_10g_alle_Spalten.pkg und Vergleich_11g_alle_Spalten.pkg
SET FEEDBACK ON