本文发表在 rolia.net 枫下论坛我用SQL LOADER(SQLLDR80)拷贝两个关联表进ORACLE。
结果,在ORACLE中可以看见这些记录,但不能删除。(执行删除时,ORACLE死掉)。
相关语句如下:
COMMAND:
QLLDR80.EXE maximo/maximo control= C:\export\SQLLDR\loadjpoperation.dat,
log= C:\export\SQLLDR\loadjpoperation.log, bad= C:\export\SQLLDR\loadjpoperation.bad bindsize=65536 ROWS=2013
LOG:
SQL*Loader: Release 8.0.4.0.0 - Production on Tue Mar 12 8:25:43 2002
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Control File: C:\EXPORT\SQLLDR\loadjpoperation.dat
Data File: C:\export\sqlldr\JPOperation.txt
Bad File: C:\EXPORT\SQLLDR\loadjpoperation.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 2013 rows, maximum of 65536 bytes
Continuation: none specified
Path used: Conventional
Table JOBOPERATION, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
JPNUM FIRST * , O(") CHARACTER
JPOPERATION NEXT * , O(") CHARACTER
DESCRIPTION NEXT * , O(") CHARACTER
OPDURATION NEXT * , O(") CHARACTER
ROWSTAMP SEQUENCE (MAX, 1)
Table JOBOPERATION:
2013 Rows successfully loaded.
0 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.
Space allocated for bind array: 65410 bytes(62 rows)
Space allocated for memory besides bind array: 0 bytes
Total logical records skipped: 0
Total logical records read: 2013
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Tue Mar 12 08:25:43 2002
Run ended on Tue Mar 12 08:37:19 2002
Elapsed time was: 00:11:36.61
CPU time was: 00:00:00.00更多精彩文章及讨论,请光临枫下论坛 rolia.net
结果,在ORACLE中可以看见这些记录,但不能删除。(执行删除时,ORACLE死掉)。
相关语句如下:
COMMAND:
QLLDR80.EXE maximo/maximo control= C:\export\SQLLDR\loadjpoperation.dat,
log= C:\export\SQLLDR\loadjpoperation.log, bad= C:\export\SQLLDR\loadjpoperation.bad bindsize=65536 ROWS=2013
LOG:
SQL*Loader: Release 8.0.4.0.0 - Production on Tue Mar 12 8:25:43 2002
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Control File: C:\EXPORT\SQLLDR\loadjpoperation.dat
Data File: C:\export\sqlldr\JPOperation.txt
Bad File: C:\EXPORT\SQLLDR\loadjpoperation.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 2013 rows, maximum of 65536 bytes
Continuation: none specified
Path used: Conventional
Table JOBOPERATION, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
JPNUM FIRST * , O(") CHARACTER
JPOPERATION NEXT * , O(") CHARACTER
DESCRIPTION NEXT * , O(") CHARACTER
OPDURATION NEXT * , O(") CHARACTER
ROWSTAMP SEQUENCE (MAX, 1)
Table JOBOPERATION:
2013 Rows successfully loaded.
0 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.
Space allocated for bind array: 65410 bytes(62 rows)
Space allocated for memory besides bind array: 0 bytes
Total logical records skipped: 0
Total logical records read: 2013
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Tue Mar 12 08:25:43 2002
Run ended on Tue Mar 12 08:37:19 2002
Elapsed time was: 00:11:36.61
CPU time was: 00:00:00.00更多精彩文章及讨论,请光临枫下论坛 rolia.net