[465] in Tooltime

home help back first fref pref prev next nref lref last post

help tools data load

daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Tue Nov 4 07:16:08 1997

Date: Tue, 4 Nov 1997 07:20:15 -0500
To: tooltime@MIT.EDU
From: Steven Wade Neiterman <wade@MIT.EDU>

Debi and team,

The data in the help tools Oracle database was reloaded, previous records
were deleted.

Debi, here are the results from the load.

I conducted only about two minutes of testing, it seemed to look good.  It
would be good if someone could take a further look using Scopus.

Thanks,

..Steve

mit_log table load:

Record 98: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 100: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 174: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 205: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 254: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 331: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 350: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 366: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 413: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 650: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 1161: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 1545: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 1797: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number
Record 2075: Rejected - Error on table MIT_LOGS, column MIT_TAKEN_BY
ORA-01722: invalid number

The following index(es) on table MIT_LOGS were processed:

Table MIT_LOGS:
  2387 Rows successfully loaded.
  14 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

netinstall table load:

Record 43: Rejected - Error on table MIT_NI.
ORA-01401: inserted value too large for column


Table MIT_NI:
  528 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.



home help back first fref pref prev next nref lref last post