Oracle Live SQL - Script: Session 01

Statement 1

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

Table created.

Statement 2

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

Index created.

Statement 3

CREATE TABLE "RHOMBUS_PRODUCTION"."VRM_SNAPSHOT_TMP"  
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-01918: user 'RHOMBUS_PRODUCTION' does not exist

More Details: https://docs.oracle.com/error-help/db/ora-01918

Statement 4

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

Table created.

Statement 5

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 6

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

Index created.

Statement 7

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

Index created.

Statement 8

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 9

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 10

SELECT * FROM TABLE1


SNAPSHOT_ID FLEET_BUCKET_ID
2020-08-16-28-315 8
2020-08-16-28-709 6

2 rows selected.

SNAPSHOT_ID	FLEET_BUCKET_ID
2020-08-16-28-315	8
2020-08-16-28-709	6

Statement 11

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 12

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 13

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 14

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 15

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 16

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 17

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 18

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 19

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 20

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 21

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 22

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 23

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 24

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 25

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 26

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 27

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 28

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 29

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 30

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 31

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 32

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 33

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 34

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 35

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 36

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 37

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 38

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 39

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 40

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 41

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 42

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 43

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 44

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 45

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 46

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 47

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 48

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 49

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 50

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 51

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 52

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 53

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 54

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 55

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 56

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 57

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 58

create table TABLE1 ( 
    SNAPSHOT_ID varchar2(50), 
    FLEET_BUCKET_ID number(3,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 59

CREATE INDEX TABLE1_IDX1 ON TABLE1 ("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 60

CREATE TABLE TABLE2 
(	"SNAPSHOT_ID" VARCHAR2(50 BYTE),  
	"VRM_ID" VARCHAR2(50 BYTE),  
	"SNAP_TIME_ID" NUMBER(4,0),  
	"SNAP_DATETIME" TIMESTAMP (6),  
	"ETL_LOG_ID" VARCHAR2(12 BYTE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 61

CREATE INDEX TABLE2_IDX1 ON TABLE2("SNAPSHOT_ID")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 62

CREATE INDEX TABLE2_IDX2 ON TABLE2("SNAP_DATETIME")

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 63

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-315',8)

1 row(s) inserted.

Statement 64

Insert into TABLE1 (SNAPSHOT_ID,FLEET_BUCKET_ID) values ('2020-08-16-28-709',6)

1 row(s) inserted.

Statement 65

SELECT * FROM TABLE1 
 
Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 66

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 67

SELECT * FROM TABLE2


SNAPSHOT_ID VRM_ID SNAP_TIME_ID SNAP_DATETIME ETL_LOG_ID
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-315 20200816-7483 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953
2020-08-16-28-709 20200816-7355 28 16-AUG-20 02.20.00.000000 AM 363953

8 rows selected.

SNAPSHOT_ID	VRM_ID	SNAP_TIME_ID	SNAP_DATETIME	ETL_LOG_ID
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-315	20200816-7483	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953
2020-08-16-28-709	20200816-7355	28	16-AUG-20 02.20.00.000000 AM	363953

Statement 68

TRUNCATE TABLE TABLE2

Table truncated.

Statement 69

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-315','20200816-7483',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Statement 70

Insert into TABLE2 (SNAPSHOT_ID,VRM_ID,SNAP_TIME_ID,SNAP_DATETIME,ETL_LOG_ID) values ('2020-08-16-28-709','20200816-7355',28,to_timestamp('16-AUG-20 02.20.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'363953')

1 row(s) inserted.

Session 01

Additional Information