CREATE TABLE DISKSSPACE
(
DRIVELETTER CHAR(1 BYTE),
DRIVETYPE VARCHAR2(30 BYTE),
TOTALSPACE NUMBER(15),
FREESPACE NUMBER(15),
FILESYSTEM VARCHAR2(15 BYTE),
VOLUMELABEL VARCHAR2(30 BYTE),
SERIAL VARCHAR2(30 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY FLATDIR
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
BADFILE FLATDIR:'DI.bad'
logfile FLATDIR:'ext.log'
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
( DriveLetter,DriveType,TotalSpace,FreeSpace,FileSystem,VolumeLabel,SERIAL
)
)
LOCATION (FLATDIR:'di.txt')
)
REJECT LIMIT 0
NOPARALLEL
NOMONITORING; |