_____________________________________________________________________________________

_____________________________________________________________________________________

connect /as sysdba

drop user hajo cascade;

create user hajo identified by hajo;

grant connect to hajo;
grant create table to hajo;

alter user hajo quota unlimited on users;

conn hajo/hajo

CREATE TABLE table_one (
  col_one NUMBER,
  col_two VARCHAR2(10)
);
 
CREATE TABLE table_two (
  col_three NUMBER,
  col_four  VARCHAR2(10)
);
 
INSERT INTO table_one VALUES ( 1,    'one');
INSERT INTO table_one VALUES ( 2,    'two');
 
INSERT INTO table_two VALUES (10,    'ten');
INSERT INTO table_two VALUES (20, 'twenty');
INSERT INTO table_two VALUES ( 5,   'five');
 
SELECT * FROM
  table_one cross join
  table_two;

connect /as sysdba

drop user hajo cascade;

-----------------------------------------------------------------------------

insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);

insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);

insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);

insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);
insert into table_one (select * from table_one);



insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);

insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
insert into table_two (select * from table_two);
_____________________________________________________________________________________