SQL*Plus: Release 3.3.2.0.0 - Production on Tue Jun 9 16:14:05 1998 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release PL/SQL Release 2.3.2.0.0 - Production SQL> SQL> SQL> SQL> SQL> DROP TABLE WDS_TT * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> 2 3 4 5 6 7 8 9 10 11 Table created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> 2 3 4 5 1 row created. SQL> SQL> RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 5 57 40 0 2 BU 1190 6.5 08-NOV-88 31-DEC-99 0 0 0 75 30 A 1248 12 12-MAR-89 15-NOV-92 4 13 20 50 32 CHR 15 15.5 09-FEB-90 31-DEC-99 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 1 23 70 -9 55 HJ 3433 10.5 25-MAR-91 31-DEC-99 0 0 9 75 30 A 1248 12 15-NOV-92 18-MAY-94 2 33 10 -9 25 LDS3402 10.6 19-DEC-93 09-JUL-96 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 0 0 9 75 30 A 1248 10.5 18-MAY-94 23-JUL-95 0 0 8 75 30 A 1248 10.5 23-JUL-95 31-DEC-99 8 rows selected. SQL> SQL> DROP TABLE WDS * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> 2 3 4 5 6 7 8 9 Table created. SQL> SQL> 2 3 4 5 6 4 rows created. SQL> SQL> RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- 5 57 40 0 2 BU 1190 6.5 4 13 20 50 32 CHR 15 15.5 1 23 70 -9 55 HJ 3433 10.5 0 0 8 75 30 A 1248 10.5 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 Trigger created. SQL> SQL> 2 3 4 5 6 7 7 Trigger created. SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 13 Trigger created. SQL> SQL> SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> 1 row deleted. SQL> SQL> 1 row updated. SQL> SQL> RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- 5 57 40 0 2 BU 1190 6.5 4 13 20 50 32 CHR 15 15.5 1 23 70 -9 55 HJ 3433 10.5 0 0 8 75 30 A 1248 10.5 0 8 0 31 33 STT 256 7.9 SQL> SQL> RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 5 57 40 0 2 BU 1190 6.5 08-NOV-88 31-DEC-99 0 0 0 75 30 A 1248 12 12-MAR-89 15-NOV-92 4 13 20 50 32 CHR 15 15.5 09-FEB-90 31-DEC-99 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 1 23 70 -9 55 HJ 3433 10.5 25-MAR-91 31-DEC-99 0 0 9 75 30 A 1248 12 15-NOV-92 18-MAY-94 2 33 10 -9 25 LDS3402 10.6 19-DEC-93 09-JUL-96 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 0 0 9 75 30 A 1248 10.5 18-MAY-94 23-JUL-95 0 0 8 75 30 A 1248 10.5 23-JUL-95 31-DEC-99 0 2 0 60 57 ES 1933 2.4 09-JUN-98 09-JUN-98 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- TRANS_STA TRANS_STO --------- --------- 0 8 0 31 23 STT 256 7.9 09-JUN-98 09-JUN-98 0 8 0 31 33 STT 256 7.9 09-JUN-98 31-DEC-99 11 rows selected. SQL> SQL> SQL> SQL> 2 3 4 RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- 5 57 40 0 2 BU 1190 6.5 4 13 20 50 32 CHR 15 15.5 1 23 70 -9 55 HJ 3433 10.5 0 0 8 75 30 A 1248 10.5 0 8 0 31 33 STT 256 7.9 SQL> SQL> SQL> SQL> 2 3 4 5 6 View created. SQL> SQL> RA_HOUR RA_MIN RA_SEC DEC_DEGREE DEC_MINUTE DISCOVE MAG_FIRST ---------- ---------- ---------- ---------- ---------- ------- ---------- 5 57 40 0 2 BU 1190 6.5 4 13 20 50 32 CHR 15 15.5 1 23 70 -9 55 HJ 3433 10.5 0 0 9 75 30 A 1248 12 2 33 10 -9 25 LDS3402 10.6 SQL> SQL> SQL> SQL> DISCOVE ------- BU 1190 HJ 3433 A 1248 STT 256 SQL> SQL> SQL> SQL> DISCOVE ------- BU 1190 HJ 3433 LDS3402 SQL> SQL> SQL> SQL> 2 3 MAG_FIRST TRANS_STA TRANS_STO ---------- --------- --------- 12 12-MAR-89 15-NOV-92 12 15-NOV-92 18-MAY-94 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 DISCOVE TRANS_STA TRANS_STO ------- --------- --------- HJ 3433 18-MAY-94 23-JUL-95 HJ 3433 23-JUL-95 31-DEC-99 SQL> SQL> SQL> SQL> 2 3 4 5 DISCOVE OLD_VALUE NEW_VALUE WHEN_CHAN ------- ---------- ---------- --------- A 1248 0 9 15-NOV-92 A 1248 9 8 23-JUL-95 SQL> SQL> Table dropped. SQL> SQL> Trigger dropped. SQL> SQL> Trigger dropped. SQL> SQL> Trigger dropped. SQL> SQL> SQL> SQL> DROP TABLE WDS_B * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> 2 3 4 5 6 7 8 Table created. SQL> SQL> 2 3 4 5 6 1 row created. SQL> SQL> 2 3 4 5 6 1 row created. SQL> SQL> 2 3 4 5 6 1 row created. SQL> SQL> DISCOVE MAG_FIRST TRANS_STA TRANS_STO VALID_FRO VALID_TO ------- ---------- --------- --------- --------- --------- A 1248 12 12-MAR-89 15-NOV-95 14-MAY-22 31-DEC-99 A 1248 12 15-NOV-95 31-DEC-99 14-MAY-22 16-OCT-94 A 1248 10.5 15-NOV-95 31-DEC-99 16-OCT-94 31-DEC-99 SQL> SQL> SQL> SQL> 2 3 4 5 View created. SQL> SQL> DISCOVE MAG_FIRST VALID_FRO VALID_TO ------- ---------- --------- --------- A 1248 12 14-MAY-22 31-DEC-99 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 DISCOVE WHEN_CHAN VALID_FRO VALID_TO ------- --------- --------- --------- A 1248 15-NOV-95 14-MAY-22 16-OCT-94 SQL> SQL> Table dropped. SQL> SQL> Table dropped. SQL> Disconnected from Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release PL/SQL Release 2.3.2.0.0 - Production