big_table.log

Expert Oracle Database Architecture 9i and 10g sql源码

SQL*Loader: Release 10.1.0.4.0 - Production on Tue Sep 27 08:02:59 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Control File:   big_table.ctl
Data File:      /tmp/big_table.dat
  Bad File:     big_table.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation:    none specified
Path used:      External Table

Table BIG_TABLE, loaded from every logical record.
Insert option in effect for this table: REPLACE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID                                  FIRST     *   |       CHARACTER            
OWNER                                NEXT     *   |       CHARACTER            
OBJECT_NAME                          NEXT     *   |       CHARACTER            
SUBOBJECT_NAME                       NEXT     *   |       CHARACTER            
OBJECT_ID                            NEXT     *   |       CHARACTER            
DATA_OBJECT_ID                       NEXT     *   |       CHARACTER            
OBJECT_TYPE                          NEXT     *   |       CHARACTER            
CREATED                              NEXT     *   |       CHARACTER            
LAST_DDL_TIME                        NEXT     *   |       CHARACTER            
TIMESTAMP                            NEXT     *   |       CHARACTER            
STATUS                               NEXT     *   |       CHARACTER            
TEMPORARY                            NEXT     *   |       CHARACTER            
GENERATED                            NEXT     *   |       CHARACTER            
SECONDARY                            NEXT     *   |       CHARACTER            



CREATE DIRECTORY statements needed for files
------------------------------------------------------------------------
CREATE DIRECTORY SYS_SQLLDR_XT_TMPDIR_00000 AS '/home/tkyte/txt/chapter14'


CREATE TABLE statement for external table:
------------------------------------------------------------------------
CREATE TABLE "SYS_SQLLDR_X_EXT_BIG_TABLE" 
(
  "ID" NUMBER,
  "OWNER" VARCHAR2(30),
  "OBJECT_NAME" VARCHAR2(30),
  "SUBOBJECT_NAME" VARCHAR2(30),
  "OBJECT_ID" NUMBER,
  "DATA_OBJECT_ID" NUMBER,
  "OBJECT_TYPE" VARCHAR2(19),
  "CREATED" DATE,
  "LAST_DDL_TIME" DATE,
  "TIMESTAMP" VARCHAR2(19),
  "STATUS" VARCHAR2(7),
  "TEMPORARY" VARCHAR2(1),
  "GENERATED" VARCHAR2(1),
  "SECONDARY" VARCHAR2(1)
)
ORGANIZATION external 
(
  TYPE oracle_loader
  DEFAULT DIRECTORY MY_DIR
  ACCESS PARAMETERS 
  (
    RECORDS DELIMITED BY NEWLINE CHARACTERSET WE8ISO8859P1
    BADFILE 'SYS_SQLLDR_XT_TMPDIR_00000':'big_table.bad'
    LOGFILE 'big_table.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY "|" LDRTRIM 
    REJECT ROWS WITH ALL NULL FIELDS 
    (
      "ID" CHAR(255)
        TERMINATED BY "|",
      "OWNER" CHAR(255)
        TERMINATED BY "|",
      "OBJECT_NAME" CHAR(255)
        TERMINATED BY "|",
      "SUBOBJECT_NAME" CHAR(255)
        TERMINATED BY "|",
      "OBJECT_ID" CHAR(255)
        TERMINATED BY "|",
      "DATA_OBJECT_ID" CHAR(255)
        TERMINATED BY "|",
      "OBJECT_TYPE" CHAR(255)
        TERMINATED BY "|",
      "CREATED" CHAR(255)
        TERMINATED BY "|",
      "LAST_DDL_TIME" CHAR(255)
        TERMINATED BY "|",
      "TIMESTAMP" CHAR(255)
        TERMINATED BY "|",
      "STATUS" CHAR(255)
        TERMINATED BY "|",
      "TEMPORARY" CHAR(255)
        TERMINATED BY "|",
      "GENERATED" CHAR(255)
        TERMINATED BY "|",
      "SECONDARY" CHAR(255)
        TERMINATED BY "|"
    )
  )
  location 
  (
    'big_table.dat'
  )
)REJECT LIMIT UNLIMITED


INSERT statements used to load internal tables:
------------------------------------------------------------------------
INSERT /*+ append */ INTO BIG_TABLE 
(
  ID,
  OWNER,
  OBJECT_NAME,
  SUBOBJECT_NAME,
  OBJECT_ID,
  DATA_OBJECT_ID,
  OBJECT_TYPE,
  CREATED,
  LAST_DDL_TIME,
  TIMESTAMP,
  STATUS,
  TEMPORARY,
  GENERATED,
  SECONDARY
)
SELECT 
  "ID",
  "OWNER",
  "OBJECT_NAME",
  "SUBOBJECT_NAME",
  "OBJECT_ID",
  "DATA_OBJECT_ID",
  "OBJECT_TYPE",
  "CREATED",
  "LAST_DDL_TIME",
  "TIMESTAMP",
  "STATUS",
  "TEMPORARY",
  "GENERATED",
  "SECONDARY"
FROM "SYS_SQLLDR_X_EXT_BIG_TABLE"


statements to cleanup objects created by previous statements:
------------------------------------------------------------------------
DROP TABLE "SYS_SQLLDR_X_EXT_BIG_TABLE"
DROP DIRECTORY SYS_SQLLDR_XT_TMPDIR_00000



Run began on Tue Sep 27 08:02:59 2005
Run ended on Tue Sep 27 08:02:59 2005

Elapsed time was:     00:00:00.23
CPU time was:         00:00:00.04