Home

マルチ・スレッド・アンローダーバージョン 4.2.3 取扱説明書 2015 年 3 月

1.
2. 9 1 8 60 9 1 4 A B
3. PLUMSX mtu v4 2 bit FI CXTEMPXMTU HOME robocopy HOME E output Env bat OUTPUT robocopy HOME E XD output v4 2 3 191 PLUMSIX Co Ltd
4. Not Null Windows Shift SJIS NCLOB AL16UTF16 UTF 16 Big Endian v4 2 3 15 PLUMSIX Co Ltd
5. MNGSCROUT 86 Hi SKIPSCR 96 Bi 4 2 Query SELECT CSV CSV QUERYVAR 92 El QUERYFIX 91 B EXTNAMESQL 80 A QUERYVAR 92 QUERYFIX 91 B
6. query C Windows system32 gt logman query mtu_parf_log mtu parf log systemdr ive PerfLogs Admin SYSTEM 1 5 2013 3 50 00 PM mtu parf logYmtu parf log va p je p 60 LogicalDisk Avg Disk bytes Write YLogicalDiskYAvg Disk sec Write YXLogicalDiskXAvg Disk Write Queue Length YLogicalDiskYDisk Write Bytes sec XProcessor Total Processor Time v4 2 3 165 PLUMSIX Co Ltd E SE dei ds 24 2 2
7. 9 1 1 v4 2 3 52 PLUMSIX Co Ltd MTU B m
8. SORTED INDEXES USUALPATH 99 diff SORT_AREA SIZE SQL alter session set sort_area_size CBO Query
9. b INPUT 83 FILEBIND 80 key value key value value to_date
10. 16 132 RERUNPOINT gt REVERSEBYTEORDER Windows Little Endian Big Endian CHARSETFORM 2 NCHAR NVARCHAR2
11. MTU DFILE ALT DIRS MINIMUM FREE SIZE 1 MTU xxx xxx MINIMUM FREE SIZE DFILE_ALT_DIRS A B C MTU Information DFILE ALT DIR
12. PGA v4 2 3 101 PLUMSIX Co Ltd h i ID v session v session sys sys
13. CBO Oracle Database CPU I O busy v4 2 3 153 PLUMSIX Co Ltd 22 Oracle Database Pro COBOL MTU MTU SAM Sequential Access Method
14. EXCEPTIONS 4 5 3 GetFkrb v4 2 3 18 PLUMSIX Co Ltd CASCADE CONSTRAINTS DROP TABLE SQL 4 5 4 GetTbIP 4 5 5
15. 3 2 3 9 1 9 61 v4 2 3 54 OPLUMSIX Co Ltd UR gt CPU RADE ED
16. FILE_FLAG_NO_BUFFERING IO OVERLAP SCALE 84 v4 2 3 20 PLUMSIX Co Ltd PARTITIONING 89
17. MTU 043 223 5202 info plumsix jp 90 043 223 5206 mtu_support plumsix co jp v4 2 3 194 PLUMSIX Co Ltd 34 Multi threaded Unloader ORACLE Oracle Corporation Microsoft
18. CTRL C 12 2 UnLoad 1 43 Env bat Env bat 11 70 2 Envjbat UnLoad bat 3 C ProgramData PLUMSIXWntu_4 2 x86 gt unload Multi threaded Unloader version 4 2 12 1 100 0 00 v4 2 3 102 PLUMSIX Co Ltd L3 3 4 Z 19 0 00
19. OQ MAC U gt to Eld Esp AU i d A A E DE H c ot vva c i O URL HTTP UI Huk 0 PEO ce
20. 33 190 ok ok ox 9 1 3 54 9 1 4 55 9 1 3 2
21. c Not NULL d ALL_CONSTRAINTS ALL_ TRIGGERS STATUS define 0BJOWNER SRC_USER select constraint_name constraint_type status from all_constraints where owner amp OBJOWNER select trigger name trigger type status from all triggers where owner amp OBJOWNER 12 8 3 GetFkrb 1 43 Env bat Env bat
22. v4 2 3 55 OPLUMSIX Co Ltd gt 226 AQIAABBnAAAApAAAMhDAVSK7bM3bIFStNt7qkOw DrsTA ASGBNy i3y ITtnYEH 02 ZWHtoBooAwBuz 1251 73hy JnXsyallGli3GybGrt f 8j 285 rxnRMSG nh8e02221l JBezrpBxWK3V rDmitejdzsI ksfhCPyHSwdhMB2TFIzjWQI5BdiRQng AQIAABBRAAAApAAAMhDAVSKTbMSbIFStNtTakCw DrsTA ABOBNy 13y l ITtnYEH ZWHtoBoo wBuziz5173hyJnXsyqUQW3GybGrtf8qj2a5rxnRMSGjnjnhSe0z22W JBezrp amp xVK3V rDnitejSzsIAlksf bCPyHSwah8MB2TFIzjWGl56diROng BKY20 ED3NS SFTF3 THVVD LYZ2A P ssp remm Vy 1 MAC GOMA o CE CPU CR CPU
23. env batsignlcs datlicense dat input qryvar qryfix 7 3 2 v4 2 12 MTU OS x86
24. 9 1 5 57 9 1 5 ok ok ox 9 1 1 52 8 v4 2 3 57 OPLUMSIX Co Ltd
25. LONGTRANSIT 0 LONG LONG RAW CSV 1 CLOB BLOB OS 2 BFILE OS LONGTRANSIT 2 DIRALIAS 77 E 34528 C3 0 lt MAXLONGSIZE lt 32 LONG LONG RAW LONG LONG RAW LONG LONG RAW Warning LONG LONG RAW LONG LONG RAW
26. INSERT APPEND REPLACE DELETE TRUNCATE TRUNCATE SQL Loader INSERT _trunc sql OUTPUT TRUNCATE TABLE PL SQL ALTER TABLESPACE ALTER TABLESPACE COALESCE
27. SRC_USER 97 2 lt gt FILETABLE 82 LISTTABLE 3 lt gt ISTFIXED 84 SAM LISTTABLE FILETABLE 2 Windows
28. 11g TEMPLATE 4749 STORE IN LOCAL CREATE SQL 2 TEMPLATE LOCAL v4 2 3 23 OPLUMSIX Co Ltd create table TEST24 aria id NUMBER 4 mp id NUMBER 4 item id NUMBER 4 tagno CHAR 10 dt DATE value NUMBER 12 3 Status NUMBER 4 constraint test24 pk primary key aria id mp id item id initial 128k next 128k minextents 1 maxextents 65536 partition by range dt subpartition by list item id subpartition template subpartition pl values 1 8 9 tablespace PARI Subpartition p2 values 2 4
29. bit 1 Lum x86 x64 64 bit Windows nn 3 11 43 Windows
30. MTU CONSISTENT 76 Ei ASM Automatic Storage Management RAW OCFS Oracle Oracle RAOC Real Application Clustery Unicode Unicode 13 Unicode 125 CHARSETID 75
31. v4 2 3 116 PLUMSIX Co Ltd Oracle 10g 128 d J 12 7 GetMeta 1 43 Enba Env bat 11 70
32. INPUT 83 A GetTbIN v4 2 3 82 PLUMSIX Co Ltd GetTbIP OUTPUT 89 5
33. uH Waka Wasa ERIGI CRRIROR DELE mx E d p s h 0
34. 6 3 32 I release txt I v4 2 3 10 PLUMSIX Co Ltd 2 UnLoad Query SQL Loader truncate table GetMeta
35. v4 2 3 148 PLUMSIX Co Ltd WaitNamedPipe 19 2 144 30 146 ED v4 2 3 149 PLUMSIX Co Ltd 20 ROWID_SPLIT_MIN_SIZE 94 1 ROWID PARALLELISM 90 2 10
36. Oracle Database 11g SET SEC CASE SENSITIVE LOGON TRUE OK v4 2 3 129 OPLUMSIX Co Ltd P U R TRACER pm Xx64X input userid crc NM C SYSDBA A C SYSOPER O CANCEL EQUES 15 1 2 No 2 F U SYSTEM 7 BAHR eea 7 MM C SYSDBA A C SYSOPER O output dst_info crd
37. C ProgramData PLUMSIX mtu_4 2 x86 gt QikExp SYSTEM SYSTEM 0111UTF8 SCOTT select into EMP from EMP b jobs SALESMAN output Ox09 0x22 y n y QikExp dat Multi threaded Unloader version 4 2 12 1 100 output TableName NumRows Elapse Rows s Bytes kB s Len EMP 14 0 02 601 905 44 64 1 kbytes kbytes 63 1 51 16 85 0 09 a 25 25 v4 2 3 112 PLUMSIX Co Ltd b
38. DBA_SEGMENTS USER_SEGMENTS lt gt initial initial_extent bytes next initial extent next extent minextents min extents 1 CONSISTENT 8 output Repeatable read ORA 01555 v4 2 3 76 PLUMSIX Co Ltd DATAEXT CSV
39. v4 2 3 48 OPLUMSIX Co Ltd 1 Install C XProg Multi threaded Unl c 2003 Plums ido IS Q T Number of NU Number o Numbe pt Number of processor 11 12 13 caches 4 s EM t 6 4 33 ED 9 52 Install bat c ProgramData PLUMSIX mtu_4 2 x64 gt install Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved Windows 7 Professional build 7600 64 bit native Numbe
40. Window MTU 2 WinMain 7 Window AllocConsole v4 2 3 144 OPLUMSIX Co Ltd 8 set STDOUT Ox0001 set STREAM LOCATOR ipc_pipe zip ON DzyyyyMMdd W HHmmss E SRC USER v MTU
41. Oracle Database 10g PARTITIONING 89 0 23 2 1 BOM CLOB 10 LOB 0 9 10 NOBYTEORDER LOB UTF 16BE MARK 87 NCLOB LOB LOB 4 LOB PDF BLOB LOB 4
42. BFILE DBMS_STATS UnLoad Query 2 a
43. 7 2 v4 2 v4 1 v4 2 v4 2 7 3 v3 06 v4 2 7 3 1 v4 2 12 v4 2 3 37 CPU
44. v4 2 3 59 OPLUMSIX Co Ltd 0 EE gt ij Favorites si 1 AUN 4 McAfee l xe 1 Microsoft Microsoft Help apply dat Mozilla 1 2 authenticate dat n OBER6 license dat b J PLUMSIX E 2 12 Jj mtu 4 1 d x64 0 8D7QM XY3X7 LINIP QGOML 7J3F5 1 ESE 5SR LU CP ys ek ti I 2 1150 2 un E 8 WS JU UU eee
45. 18 139 DB create or replace directory as grant read write on directory to LONGTRANSIT 2 DB DISCRE TE KED CSV BEGINDATA CSV
46. 1 PARALLELISM 90 BULK_SIZE 75 E BULK SIZE BULK SIZE 16kB kiM G T P BULK SIZE 1 lt S BULK SIZE lt 32 BIND_SIZE 75 PARALLELISM 90 300 2000
47. del Xlicense dat v4 2 3 65 PLUMSIX Co Ltd 9 1 52 D PLUMSIX MTU v4 1 32 bit BR GetMeta xil Query UnLoad Jg koka 9 X Gg X 4 v4 2 3 66 PLUMSIX Co Ltd 10
48. NULL 3 __ PRESERVE BLANKS 6 7 TIMESTAMP WITH LOCAL TIME ZONE SQL Loader TIMESTAMP WITH LOCAL TIME ZONE
49. 33 0 1 v4 2 3 170 PLUMSIX Co Ltd 27 27 1 Error OCLDLL Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved Windows 7 Professional Service Pack 1 build 7601 64 bit native Number of NUMA nodes 1 Number of physical processor packages 1 Number of processor cores 2 Number of logical processors 2 Number of processor L1 L2 L3 caches 4 1 0 Error Win32API Code 0x7e Msg rcChkWin32Api O rcChkWin32Api c 46 Error OCI DLL
50. MERGE_LOBS_INTO_SDF 859 Oracle9i TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND Oracle10g BINARY FLOAT BINARY DOUBLE LF SQL Loader RECLENGTH 93 2GB 2 31 1 LONG LONG RAW MAXLONGSIZE 85 B LONG RU LONG RAW SQL Loader CLOB BLOB BFILE CLOB BLOB I BFILE
51. true E false set lt gt true set lt gt false set lt gt 11 2 2 K Windows C Shell Boune Shell 7 ALLUSERSPROFILE PLUMSIX mtu_4 2 x86 ALLUSERSPROFILE PLUMSIX mtu_4 2 x64 v4 2 3 70 OPLUMSIX Co Ltd 11 2 3
52. 7 1 v4 1 v4 2 v4 1 v4 2 v4 1 Envbat 11 43 v4 1 license dat
53. LISTFIXED LISTTABLE 84 FILETABLE 82 30 LISTTABLE 30 _ v4 2 3 84 PLUMSIX Co Ltd
54. FILEMETA 81 ED METADIV 85 B 4 5 4 5 1 4 2 16 Query Microsoft Excel Excel 2 4
55. USERID DSTINFO 78 k SQL Loader USERID DST INFO l wait here bat _make bat MPX _make bat LOADMETHOD 85 INSERT trunc sql truncate table truncate table
56. k MPX MPX 21 MPX MPX Completed successfully 0 Failed with an error 0 12 6 Re load bat 1 DSTINFO 78 E lt username gt lt password gt lt db_alias gt lt username gt lt password gt 3 2 DST INFO
57. Windows Server 2008 16TB Windows Server 2012 255TB BFILE OS 10g Oracle Client BLOB CLOB NCLOB 4GB 1 getClobVal Query CLOB XML CLOB SQL Loader XMLType getClobVal sample GetClobVal sql LONG LONG RAW SQL Loader
58. ISTFIXED 84 H FILEFIXED 81 H N NUM ROWS 88 E SQL Loader UnLoad MNGSCROUT 86 SKIPSCR 96 E 1 GRANT ANY ROLE GRANT ANY PRIVILEGE SYS SYSTEM 1 1 a 1 2 PUBLIC a
59. STREAM LOCATOR 98 Oracle8i SQL Loader 0x 16 ENCLOSER2 ENCLOSER2 ENCLOSER mojimojl ENCLOSER ENCLOSER2
60. Unload 154 Query 155 155 B 155 B SAM BCD UTF 16BE Windows 16 22 1 Unload Unload Unload SELECT MVIEW Unload Query 1 lt gt ISTTABLE 84
61. INFILE FILESIZE 82 Ei Oracle 8 CLOB NCLOB BLOB LOB LOBFILE LOB SDF Oracle 10g 4GB LOB LOBFILE LOB BFILE NCHAR NVARCHAR2 v4 18 CLOB NCLOB SDF SPF LOB LOB LOBFILE
62. FGAC Unload NUM_ROWS 88 Bi 0 NUM_ROWS gt 0 select count from FGAC 1 Query NUM ROWS PRINTCOLID lt 0 5 gt MTU MPX NORMAL MTU
63. v4 2 3 40 OPLUMSIX Co Ltd bit 32 bit 64 bit 32 bit 64 bit 32 64 x86 x64 T EE rara
64. NotNull ALTER TABLE ENABLE DISABLE CONSTRANT Oracle8i SQL Loader Oracle8 SQL Loader LOB Oracle7 8 SQL Loader nologging 16 132 BFILE
65. Uninstall bat C ProgramData PLUMSIX mtu_4 2Yx64 uninstal l SQL Plus Release 11 2 0 1 0 Production on 3 H 9 16 41 03 2012 Copyright c 1982 2010 Oracle All rights reserved rem INSTALL connect SYSTEM XXXXXXX XXXXXXXXXXXXXX drop PACKAGE APLDDP01 drop TABLE APLDD101 drop TABLE APLDD102 drop TABLE APLDD103 v4 2 3 67 PLUMSIX Co Ltd drop TABLE APLDDTO4 exit Oracle Database 10g Enterprise Edition Release 10 2 0 3 0 64bit Production With the Partitioning OLAP and Data Mining options C ProgramData PLUMSIXWntu_4 2Yx64 10 2 2 UnInstall bat
66. 53 55 9 1 2 6 5 5 1 9 1 2 9 1 4
67. DIRALIAS 77 drop table create table EMP EMPNO number 4 ENAME varchar2 10 JOB varchar2 9 MGR number 4 HIREDATE date SAL number 7 2 COMM number 7 2 DEPTNO number 2 ORGANIZATION EXTERNAL TYPE ORACLE LOADER DEFAULT DIRECTORY ALIAS a ACCESS PARAMETERS RECORDS VARIABLE 10 BADFILE LOGFILE EMP FIELDS TERMINATED BY EMPNO CHAR 5 ENAME CHAR 10 ENCLOSED BY JOB CHAR 9 ENCLOSED BY MGR CHAR 5 HIREDATE DATE 14 YYYYMMDDHH24MISS ENCLOSED BY SAL CHAR 9 v4 2 3 188 PLUMSIX Co Ltd COMM CHAR 9 DEPTNO CHAR 3 LOCATION ENP dat 29 4 GetMeta Tabs 000025 drop table create table EMP 0001 EMPNO number 4 0002 ENAME varchar2 10 0003 JOB varchar2 9 0004 MGR number 4 0005 HIREDATE date 0006 x SAL number 7 2 0007 COMM number 7 2 0008 DEPTNO constraint PK EMP primary key 0001 0 not deferrable initia
68. SRC_USER 97 SELECT QUERYVAR 92 key value FILEBIND 80 e OUTPUT 89 EMBED COLUMN NAME 78 3 Y QikExp dat
69. 4 1000 H8 lt m dei T Nm TUM UU MD 58 JU JE ge CT 9 1 6 amp Rib 9 1 7 59 9 1 6 ME
70. EXTNAMESQL 80 1 1 SELECT X SELECT 1 SELECT MTU 1 2 21
71. SAM 0x00 SAM 22 154 WINTARGET 99 WINTARGET true Windows 0x0d0x0a CR LF UNIX 0x0a LF SERVEROUTPUT SERVEROUTPUT 1 32 PL SQL DBMS_OUTPUT DBMS_OUTPUT SHOWCLTDTM f
72. MPX Reload bat rem set SW_CS0 set SW_CS0 cso _stdout log set SW_CS0 set SW_CS0 cso _stdout log v4 2 3 115 OPLUMSIX Co Ltd Any Not NULL constraints were not found Any PK or AK constraints were not found Any check constraints were not found Any FK constraints were not found timing stop 00000053 Oracle Database 11g Enterprise Edition Release 11 1 0 6 0 Production With the pete OLAP Data Mining and Real Application qum 7 1 mpleted 6 305 T sqlplus nolog GSALGRADI 8 10 findstr n ORA 8 101 competed 0815 elapsed n ORA log _errmtxt 9 10 findstr n SQLY Loader 9 10 failed with ro 1 m i 0 64s
73. v4 2 3 22 PLUMSIX Co Ltd LOB LOB n MENH N NN wawas i 5 3 GetMeta CREATE meta sql grep UNIX findstr Windows METADIV 85 Ei Oracle Database 11g 5
74. v4 2 3 97 PLUMSIX Co Ltd set FILELOG mtu log FILELOG OUTPUT lt OUTPUT gt lt gt STREAM_LOCATOR fg stdout ipc_pipe named pipe FI
75. UNDO commit UNDO 0 01555 xx xx b CONSISTENT 76 Read Commited v4 2 3 34 PLUMSIX Co Ltd Non Repeatable Read Phantom Z FELT S 3R ASH ses t As
76. b P U EXCEPTIONS ROWID select from exceptions where owner lt SRC_USER gt Warning LONG LONG RAW C ProgramData PLUMSIXWntu_4 2 x86 gt unload Multi threaded Unloader version 4 2 1 2 3 BO 5 i ra 6515 4 rex Z 12 0 00 B 5 0 04 ipie Mee 1 0 46 4 output TableName i NumRows Elapse Rows s Bytes kB s Len Not NULL constr
77. O v4 2 3 41 OPLUMSIX Co Ltd H MTU Multi threaded Unloader v4 2 0 64 bit yg
78. 13 Error XXX s ConsEnable Warning ORA xxxxx C ProgramData PLUMSIXWmtu_4 2 x86 gt ConsEnable Multi threaded Unloader version 4 2 T12 1 100 Z 22 0 A 22 0 03 Warning ORA 02437 PK DEPT Warning 0RA 02270 FK DEPTNO DEPT PK DEPT P b 8 0 0 2 v4 2 3 180 PLUMSIX Co Ltd G YProgramDataYPLUMSIXYmtu 4 2Yx86
79. MTU OS Data Pump Export Data Pump Import ORACLE EXE 08 LocalSystem GUI 5 2 UnLoad
80. ROWID_SPLIT_MIN_SIZE 0 Warning ROWS ROWID SPLIT MIN SIZE 0 PARTITIONING 89 2 X PARTITIONING 2 X dat X nnnnnn dat X mm dat X mm nnnnnn dat mm X 01 16 PARALLELISM 90 ROWID mm
81. WHERE fJ START WITH 4 CONNECT BY J GROUP BY J ORDER BY HAVING INPUT 83 FILEBIND 80 8 key value FILEBIND 80 Ei SQL Loader SKIPSCR 96 Ei 4 3 ReLoad MPX exe UnLoad Query
82. EXCEPTIONS connect lt gt lt gt 9 rdbms admin utlexcpt grant select insert update delete on exceptions to public create or replace public synonym exceptions for exceptions 8 10 PLUMSIX J mtu v4 1 32 bit J mtu v4 1 64 bit ERR GetMeta Query Unload pe LF r E Env bat J X 2 mampis J 43 Installbat
83. 0 1 2 3 TIMESTAMP WITH LOCAL TIME ZONE v4 2 3 35 PLUMSIX Co Ltd gt TIMESTAMP WITH LOCAL TIME ZONE lt A7 gt ENCLOSED BY gt 3 3 gt TIMESTAMP gt ENCLOSED BY gt 3 1 2
84. INPUT 83 GetFkrb 5 CON con OUTPUT 89 GetMeta GetPlsN v4 2 3 81 PLUMSIX Co Ltd GetPlsP 0 1 lt FILESIZE lt 64
85. Oracle Client Oracle Server Oracle Client Oracle Server Error OCI Oracle 9i Release 2 v4 2 3 171 Co Ltd ORA 12154 TNS C ProgramData PLUMSIX mtu_4 2 x86 gt install Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved ORA 12154 TNS Error xxxx TNSNAMES 0RA Oracle Names 72 rcAttachToServer psOciCommon c 885 rc0ciSvc cOciSvc c 1194
86. LONG LONG RAW LONGTRANSIT 85 ORGANIZATION EXTERNAL CREATE TABLE CSV SELECT GETEXTTBL 83 9 SCN FBQSCN 80 FBQTIME 80 4 5 BFILE LONG LONG RAW
87. Oracle OS Oracle OS Oracle 11 3 Windows LISTTABLE 84 LISTFIXED 84 LISTEXCPT 84 TBL01 TBLO2 TBLO3 3 LISTEXCPT TBL LISTTABLE LISTFIXED LISTEXCPT _ URIAGE_200110 LISTEXCPT URIAGE 200110 11 4
88. v4 2 3 173 OPLUMSIX Co Ltd Error systen rc0ciSes cOciSes c 218 rc0ciSesInPool cOciSes c 285 rcAddOrDelItems cPool c 358 rcPulseOrWaitForEvent cEvent c 247 Information szltemType c0ciSes iMaxItems 0 iNumFree 0 rCtx iDifference 1 rcChgNumItemsPool cPool c 441 rcPool cPool c 526 rc0ciSvc cOc i Svc c 1327 ml 0 28 mtu c 981 C ProgramData PLUMSIXWntu_4 2 x86 gt Env bat set USERID 11g ORA 00955
89. start logman start mtu_parf_log lt 6 gt blg query 7 C Windows system32 gt logman query mtu_parf_log mtu parf log systemdr ive PerfLogs Admin SYSTEM 7 5 2013 3 50 00 PM mtu parf logYmtu parf log A c C PerfLogs Admin mtu_parf_log_000001 blg 60 LogicalDisk Avg Disk bytes Write YLogicalDiskYAvg Disk sec Write LogicalDisk Avg Disk Write Queue Length YLogicalDiskYDisk Write Bytes sec Processor _lotal Processor Time EL lt qid
90. v4 2 3 125 PLUMSIX Co Ltd 14 x64 Windows MTU x64 Windows x64 x86 WOW642 32 bit MTU WOW64 Oracle Database Oracle Oracle x64 Windows Oracle Database Client 10g for Microsoft Windows 32 bit MTU x64 Windows Oracle Database for Microsoft Windows x64 Oracle 32 bit
91. 3 LOB 2 R 10 LOB 3 C 4 LOB clo CHARSETID 75 ID 13 Unicode 125 LOB 23 LOB 156 SQL Loader
92. 1 3 0x0000 LOB OUTPUT 0x0001 0x0002 0x0003 0x0004 LOB SDF LOBFILE 3 0 env bat FILELOG 81
93. C XProgramDataYPLUMS IXXmtu 4 2 x86 gt getmeta Multi threaded Unloader version 4 2 SQL NODE sql Error SCOT APLDDTO1 SELECT rcCheckPrivsGiven cPrivsGiven c 219 rcGetMeta psGetMeta rcGetMeta c 697 kbytes 1 27 0 39 EAE kbytes 3 26 mtu c 1004 C ProgramData PLUMS IX mtu_4 2 x86 gt a 8 39 Win32API
94. 12 3 Query 1 43 Enba Env bat 11 70 2 Query bat 3 C ProgramData PLUMSIX Wmtu_4 2 x86 gt query Multi threaded Unloader version 4 2 12 1 100 1 QUERYFIX qryfix sql 2 QUERYVAR qryvar sql input bind dat b_job SALESMAN b_sal 3 1 300 b hiredate 1980 01 01 4 output TableName NumRows Elapse Rows s Bytes kB s v4 2 3 106 PLUMSIX Co Ltd SQL Loader DEPT EMP SA
95. Oracle Net Services TAF MTU TAF 1 2 3 NLS_DATE_FORMAT 5
96. 19 MTU MPX MTU MPX V3 05 v3 06 v1 03 v4 2 v1 7 MPX readme mpx pdf b env bat PARALLELISM 90 Unload Reload Unload Reload bat set a MULTIPLE PARALLELISM 2 c MPX env bat PRIORITY_CLASS 91 MPX
97. h i j m v4 2 3 4 MTU Quick Export MTU Quick Export pez 2 SYSTEM a b 4 SYSTEM wor 1 c SCOTT d select into EXP AS CSV from emp where job b job
98. DFILE_ALT_DIRS 77 MTU 7 C 3 set OUTPUT A set DFILE ALT_DIRS B C set MINIMUM FREE SIZE 25M A OUTPUT 89 AUXILIARY_ DEST 74
99. IO0_OVERLAP_SCALE 84 A lt gt _999999 DATAEXT 77 gt k M G T P STREAM_ LOCATOR 98 FILESIZE 0 FILESIZE dat clo blo LOBFILE 156 SDF 158 FILESIZE FILETABLE LISTTABLE 84 1
100. nnnnnn 14 000001 999999 DFILE_ALT_DIRS 77 FILESIZE 82 1 X ct LOAD INFILE select from v4 2 3 152 OPLUMSIX Co Ltd AS AS
101. GETEXTTBL HR DISCRETE 77 DIRALIAS 77 read write me pg O BH v4 2 3 83 PLUMSIX Co Ltd FILEBIND FILEEXCPT FILEFIXED FILETABLE POST_REP_EXEC_PLS PRE_REP_EXEC_PLS IO_OVERLAP_SCALE 0
102. SQL Loader parfile _par0 txt parfile _par1 txt WINTARGET 8 SQL Loader UNIX SQL Loader Windows CSV RECLENGTH 93 UNIX 1 Windows 2 1 100 CSV 10 110 0000000102 0000000101 v4 2 3 99 PLUMSIX Co
103. 0 MTU MTU MTU Error lt gt rc x cFileLocProc c yyy x 19 3 146 B 30 19 2 MTU E 144 Fb
104. GUI MORMAL MPX Reload bat sw EXEC_MPX pa MULTIPLE pc PRIORITY_CLASS sw 6 SW_M i findstr d 00 SW_CSI SW_CSO c make bat 20 sw v4 2 3 114 PLUMSIX Co Ltd 0 SW_HIDE 1 SW_NORMAL 6 SW_MINIMIZE e MPX Reload bat m set SW M m EXEC_LOAD EXEC_PLUS
105. OUTPUT FILETBLN 12 8 6 GetPlsP v4 2 3 122 PLUMSIX Co Ltd 1 43 Enba Env bat 11 70 2 Envbat GetPlsP bat 3 C ProgramData PLUMSIX Wmtu_4 2 x86 gt GetPlsP Multi threaded Unloader version 4 2 12 1 PL SQL CERBA output plsp txt Z 0 32 A 0 91 C 0 17
106. Oracle 2 SHOWSTAT SHOWSTMT SQL PL SQL SQL PL SQL SHOWVERS OCLDLL OCI Oracle v4 2 3 95 PLUMSIX Co Ltd C Program Fi lesYPLUMSIXYmtu 4 2Ymtu exe G 1 C oracle product 11 2 0 client_1 bin OCI DLL OC 1102000100 TF 1002000300
107. Error SEH caught an exception 0xc00000fd EXCEPTION STACK OVERFLOW C XProgramDataYPLUMS IXXmtu 4 2YXx64XoutputY mtu 05432 01 Mini dump file was saved 27 5 2 Oracle mtu exe CTRL Break v4 2 3 183 PLUMSIX Co Ltd 28 UnLoad Query SQL Loader Not Null 29 186
108. Current kB Diff KB 1 519 710 1 635 v4 2 3 132 PLUMSIX Co Ltd 16 2 UNRECOVERABLE MTU RECOVERABLE 93 Ei USUALPATH 99 UnLoad Query REDO UNRECOVERABLE UNRECOVERABLE UNRECOVERABLE UNRECOVERABLE
109. 6 4 33 Administrators Windows 9 1 MTU mtu exe VSALLUSERSPROF ILEWXPLUMS IXYmtu 4 2Y icense dat
110. CD R bit 2 10 bit bit mtu x86 msi 32 mtu amd64 msi 64 Windows Multi threaded Unloader v4 2 0 64 bit Multi threaded Unloader v4 2 0 64bit 91
111. FILLER Oracle8i 33 R8 1 6 R8 1 5 SQL Loader nvICJOB dummy v4 2 3 185 PLUMSIX Co Ltd 29 MTU EMP EMP Oracle SCOTT SCOTT Oracle 8i Windows 0RACLE_HOME rdbms admin utlsampl sal UNIX ORACLE HOME rdbms admin utlsampl sql Oracle 8i 2 rdbms admin utlsampl sql 29 1 UnLoad
112. CPU Oracle Database 10g Oracle Database 10g Standard Edition Oracle Database 10g Standard Edition One Data Pump Export Data Pump Import MTU CPU 1 O 1 0 PARALLELISM 90 Ei MVCC
113. 1 2 1 0 I O OUTPUT C Documents and Settings UNC v4 2 3 74 PLUMSIX Co Ltd 1 16384 lt BIND SIZE 32
114. NCHAR NVARCHAR2 AL16UTF16 4 lt gt REVERSEBYTEORDER 93 true CHARSETFORM 2 Intel Little Endian IBM Big Endian v4 2 3 155 PLUMSIX Co Ltd 23 LOB v4 18 2 5 LOB 2 23 1 LOBFILE LOB LOBFILE LOB
115. kbytes AERE kbytes Th C XProgramDataYPLUMS TXXmtu 4 2 x86 gt a OUTPUT FILEPLSP 82 b APLDDT02 c 500 FEEDBACK 0 c d PL SQL PL SQL OUTPUT FILEPLSP PL SQL 12 8 7 GetPlsN 1 43 Env bat
116. BULK_SIZE FEEDBACK FEEDBACK 0 b c SQL OUTPUT FILEMETA SQL 12 8 12 8 1 ConsDisable v4 2 3 118 PLUMSIX Co Ltd 1 43 Enba Env bat 11 70 2 Envbat ConsDisable bat 3 C XProgramDataYPLUMS I XXmtu 4 2Yx86 ConsDi sable Multi threaded Unloader version 4 2 12 1 100 2
117. Hik 0 ES JA N CPU CTRL C apply dat
118. Administrators 1 2 10 1 1 OpenOffice org 3 3 e Oracle OraClient11g 1 PLUMSIX mtu v4 1 64 bit x GetMeta xil Query Unload Ol 4 X o4 tv AEHSBORE X _connect sql CONNECT Uninstallbat
119. KM G T P 1M 1 8 4 O PARTITIONING v4 2 3 89 PLUMSIX Co Ltd 1 2 3 32 bit bit 1 bit 2 bit PENES PARALLELISM 4 2 ROWID SPLIT MIN SIZE 10M c r otaa TBL 02 dat 2 TBL 03
120. 27422 201543 H 31 H B PlumsiX Plumsix Co Ltd All rights reserved HX 10 NE 11 ecu SUE ud LU 12 AM MEX C 15 15 16 4 3 7 SL JUEBEI F 16 4 4 SAL XH JHB 16 LUE 18 4 51 74 UE ohm BENE enun EE 18 4 5 2 18 4 5 3 18 4 5 4 19 4 5 5 et 19 4 5 6 PL SQL 19 4 5 7 PL SQL 19 BP n DM M MU ARD LE 20 a RA UNSERE AEGRO a NOFA
121. ROWID UnLoad 1 1 CPU e 20 150 8 v4 2 3 13 PLUMSIX Co Ltd SELECT 21 152 No 12 2 Query SELECT MTU
122. BULK_SIZE 75 MERGE LOBS INTO SDF 8 CLOB NCLOB BLOB LOB LOBFILE SDF LOB LOB 23 LOB 156 METADIV v4 2 3 85 PLUMSIX Co Ltd 8 GetMeta OUTPUT 89 FILEMETA 81 GetMeta sql
123. LOB IS NULL NONE LOBFILE PDF 00000000701 TEST31 R0000000001 00002 clo TEST31 R0000000001 00003 clo 00000000463 TEST31 R0000000002 00002 1077 NONE 00000000464 TEST31 R0000000003 00002 clo NONE 00000000707 TEST31 R0000000004 00002 clo TEST31 R0000000004 00003 clo 00000000706 TEST31 R0000000005 00002 clo TEST31 R0000000005 60003 107 00000000462 NONE TEST31 R0000000006 00003 clo 00000000705 TEST31 R0000000007 00002 clo TEST31 R0000000007 0003 clo 00000000468 NONE TEST31 R0000000008 00003 clo 00000000469 TEST31 R0000000009 00002 1077 NONE 000000004710 NONE TEST31 R0000000010 00003 clo 23 1 4 LOBFILE EO LOB SQL Loader LOAD INFILE TEST31 VAR 10 INTO TABLE TEST31 TRUNCATE REENABLE FIELDS TERMINATED BY INTEGER DATA DECIMAL EXTERNAL 11 CLOB DATA LOB FILLER CHAR 28 ENCLOSED BY CLOB DATA LOBFILE CLOB DATA LOB TERMINATED BY EOF NULLIF CLOB DATA LOB NONE
124. SQL SYSTEM 1 GRANT SELECT ANY TABLE SELECT CATALOG ROLE TO lt gt 8 6 SQL Plus SQL select default tablespace temporary tablespace from user users select from user ts quotas SYSTEM DB SYSTEM UNLIMITED TABLESP
125. WAN 1kbytes 1024bytes 3 3 n 3 1 2 3 o
126. DEPENDENT gt FK ALTER TABLE ADD CONSTRAINT FOREIGN KEY REFERENCES DFILE_ALT_DIRS fm MINIMUM_FREE_SIZE 86 EMBED COLUMN NAME 78
127. v4 2 3 14 PLUMSIX Co Ltd 4 4 1 UnLoad Oracle CSV CSV TERMINATOR 98 Ei EMBED COLUMN NAME 78 ENCLOSER ENCLOSER2 78 Hi CHARSETID 75 CHARSETID 873 871 UTF 8 0 NLS LANG OS 2 UnLoad Oracle VARCHAR2 NVARCHAR2 NUMBER FLOAT LONG DATE CHAR RAW LONG RAW ROWID NCHAR BINARY_FLOAT BINARY_DOUBLE CLOB NCLOB BLOB BFILE TIMESTAMP TIMESTAMP WITH TIME ZONE
128. ORACLE_SID HKEY_LOCAL_MACHINE SOFTWARE ORACLE lt key name gt ORACLE 510 ORA 01017 C ProgramData PLUMSIX mtu_4 2 x86 gt install Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved xxxx systen Oracle Database 11g Enterprise Edition Release 11 2 0 1 0 64bit Production With the Partitioning OLAP Data Mining and Real Application Testing options cOciSes FIF0 0RA 01017 IPC Interprocess Communication 1 IPC TCP IP
129. set PARTITIONING 1 or 3 set PARTITIONING 0 or 2 SELEOT FROM WHERE rowid BETWEEN ROWID AND ROWID SELECT FROM A WHERE rowid BETWEEN ROWID AND ROWID SELECT FROM A WHERE rowid BETWEEN ROWID AND ROWID SELECT FROM A WHERE rowid BETWEEN ROWID AND ROWID 16 EXTENTS DBA OBJECTS DBA 8 5 45 EO PARALLELISM 16
130. v4 2 3 68 PLUMSIX Co Ltd 2 43 3 Oracle 4 5 9 2 62 6 OpenOffice org 3 3 1 Oracle OraClient11g home1 jj PLUMSIX J mtu v4 1 64 bit IIR ull GetMeta Qu
131. SQL Plus describe user objects 13 PL SQL APLDDTO1 APLDDT02 APLDDT03 APLDDT04 APLDDP01 E select substrb object_name 1 30 as object_name object_type status from user_objects where object name like APLDD__ INPUT 83 _connect sql _drp_Drod sql INPUT cre pub syn sql _ pub syn sql v4 2 3 51 PLUMSIX Co Ltd 9
132. v4 2 3 93 PLUMSIX Co Ltd UTF 16 Intel Little Endian IBM Big Endian UTF 16 BE ROWID_SPLIT_MIN_SIZE 0 1 ROWID_SPLIT_MIN_SIZE 64 ROWID ROWID SPLIT NUM PARTS 94
133. CPU CPU 9 1 8 60 9 1 8 CPU v4 2 3 zm SG D PU Ea Hik 0 2012 06 18 CPU 50 02 96 R 5 60 2012 06 18
134. NORMAL HIGH IDLE BELOW_NORMAL IDLE NORMAL NORMAL ABOVE_NORMAL NORMAL HIGH HIGH REALTIME QUERYFIX v4 2 3 91 PLUMSIX Co Ltd 1 1 O
135. TABLE B TABLE A TABLE E MB WB WB TABLEF 293 TABLEF 283 TABLEF 283 TABLEF 283 TABLE 221 TABLEE 221 TABLE E 220 TABLE E 221 TABLE B 175 TABLE B 175 TABLE B 175 TABLE B 175 TABLE A 63 TABLE A 69 TABLE A 63 TABLE A 63 TABLE C 54 TABLE C 54 MBE 6 54 TABLE C 54 TABLE D 23 TABLE D 23 TABLE D 23 TABLE D 23 TABLE G 10 TABLE G 10 TABLE G 10 TABLE G 10 TABLE F TABLE G TABLE D MB MB MB MB TABLEF 283 TABLEF 2983 TABLEF 283 TABLEF 283 TABLE 221 TABLEE 221 TABLEE 221 TABLIEE 221 TABLE B 175 TABLE B 175 TABLE B 175 TABLE B 175 TABLF A 63 TARLF A 63 TABLE A 63 TABLE A 63 TABLE C 54 TABLE C 54 TABLE C 54 TABLE C 54 TABLE D 23 TABLE D 29 TABLE D 23 TABLE D 23 TABLE G 10 TABLE G 10 TABLE G 10 TABLE G 10 STREAM LOCATION
136. 9 1 52 9 4 2 7 PspASCLIDLL z _ 7 2012 06 24 2012 07 01 DN 9 1 52 9 4 3
137. MTU CPU STDOUT 97 Virtual Private Database PL SQL DBMS_SESSION SET_CONTEXT PRE REP EXEC_PLS 91 POST REP EXEC PLS 90 A 1 I O AUXILIARY_DE
138. MMC 70 BREAD HFW NIH e Bm 3 mr 4 meno eno Evo Bo remar o ma 2 Oracle Primary MMC rp ER E web W Windows Server y Micn AWMI 27 01 Ex 7 E 8 7 2722 5 f ay 8 EA Microsoft Cor 9 Microsoft Cor ActiveX ActiveX
139. 19 3 iPC 146 B 19 3 named pipe pipe 256 Microsoft CreateNamedPipe IPC
140. FILEBIND key value INPUT key value set FILEBIND b job SALESMAN b sal 1300 b_hiredate 1980 01 01 QUERYFIX 91 QUERYVAR 92 SELECT v4 2 3 80 PLUMSIX Co Ltd set FILEBIND b job MANAGER b_sal 2500 set QUERYVAR select empno ename sal into LOW SAL MGR from emp where job b_job and
141. v4 2 3 56 OPLUMSIX Co Ltd A FSA AOTAABEmAAAApAAANKDAV KTON bIFS Nt 5 13 WHtoBaaAwBuziz5173hydnXsyqlGW3GyhGrtfBqj2a5rxnRMSGjnjnhSelg2zW JBezrpBxVK3V TrDmitejzsl ksfbCPyHSwh9MB2TFIzjWQI5BdiRQng 3ylITtnYEH HtnBaoAwBuziz5173hyJnXsyqlGM3GybGrtf6qj2a5rxnRHSGjnjnhSeg2zW JBezrpBxVK3V rDnitej zs IMksf bCPyHSwBh8HB2TF 12 0015691 R nz MRVE Eg sss MR 274IABBUEUR 0 GTA ed 88 CPU CPU Mozila 5 gus j OBERG Ji wes PLUMSIX Ji EntPC 2 12 licanse dat jj mtu 41 J xis Jd x06 8j Start Men ijj Sun ES RA N 4 gt
142. PARALLELISM 90 16 kiM G T P SORTING 96 ROWS 94 0 CBO E Order 2013 07 22 14 30 16 497 1318 Order 1 91M eee NON PART TABLE Order 91M 91MByte NON_PART_TABLE ROWID_SPLIT_MIN_SIZE 91M ROWID_SPLIT_NUM_PA
143. set QUERYFIX select ENAME JOB as concat name from EMP QUERYVAR 92 BD 34 0 QUERYFIX 91 PARALLELISM 90 2 QUERYVAR v4 2 3 92 PLUMSIX Co Ltd CSV TSV
144. CPU a MAC b CPU c CPU d 4
145. GetMeta 117 create DML DML v4 2 3 133 PLUMSIX Co Ltd Recovery Manager RMAN report unrecoverable C temp gt rman target Recovery Manager Release 10 2 0 3 0 Production on 12 H 27 17 20 52 2008 Copyright c 1982 2005 Oracle All rights reserved 01082 1071959426794 RMAN
146. N A LOB LOB LOB LOB Empty RU IS NULL CLOB NCLOB 10 0 LOB BLOB 4 0 23 2 2 SDF LOBFILE lt gt _C9999 gt 10 v4 2 3 158 OPLUMSIX Co Ltd CLOB NCLOB EXTNAMECLOB 79 BLOB EXTNAMEBLOB 79 9 1 10 C 23 2 3 SDF LOB
147. 3 TAF OCI Oracle Real Application Cluster RAC Oracle Fail Safe Data Guard e 17 TAF 136 ED 4 PC UnLoad MTU Query MTU VO IPC CPU
148. ipc_pipe 19 2 144 B named pipe 19 3 146 A 19 1 OS 2 MTU 29 STREAM_LOCATOR OUTPUT 89 Unload Query Unload Unload ROWID 2 Query 2 TH P OUTPUT 89
149. sample NamedPipeSinglejava java sample RebuildSequences sql sample seldom_use sql v4 2 3 192 PLUMSIX Co Ltd 36 ConsDisable bat ConsEnable bat env bat GetFkrb bat GetMeta bat SQL GetPlsN bat PL SQL GetPlsP bat PL SQL GetTbIN bat
150. 1 CHARSETFORM 1 2 AL16UTF16 NCHAR NVARCHAR2 1 CHARSETID NLS LANG Windows Oracle Database Client JA16SJISTILDE 2 o NCHAR NVARCHAR2 ASCI SQL Loader 2 Warning CHARSETFORM
151. 4 Office 2007 Office Excel Excel 5 6 MTU xla v4 2 3 L U 1 Lookup Roaming Microsoft AddIns ES Hn e Microsoft Office Excel em 67 MTU xla 2011 03 02 15 B m B amp j Subversion D N MTU xla xlam xla xill Mi
152. DB CRD CRD MTU MPX MTU DB 15 1 CRD CRD CRD E U O B 4 FA NM C SYSDBA A SYSOPER O PLUMSIX J mtu v4 1 64 bit ul GetMeta
153. QUERYFIX 91 SELECT INTO QUERYVAR 722 QUERYFILENAME Windows 1 RECLENGTH 5 CSV 10 10 LOAD INFILE VAR VAR
154. Se 9i H gr m H rs ca 26 25 v4 2 3 53 PLUMSIX Co Ltd 9 2 62
155. eost loo gt output x BE B 1 inp 2012 03 21 14 02 B eFt 2012 03 21 13 01 d 2012 03 21 12 23 B qryvar 2012 03 21 12 23 amp C u PR EI T crd HI m dst_info crd T crd ie v4 2 3 130 PLUMSIX Co Ltd E 4 outputdst_info crc
156. v4 2 3 146 PLUMSIX Co Ltd MTU 9 ABC 1 E _ 2 P1 P2_P3 P4 34 AZ EL 4 edid i m 25 X zi set STDOUT 0x0001 set STREAM LOCATOR named pipe YX YpipeY C 1 O MTU pipe
157. 5 me x URL http P 4 1 3 wa servername 2 8080 D Les bere HTTP IE URL http servername 1 8 2 8080 servername 3
158. SUPPLEMENTAL LOG DATA SUPPLEMENTAL LOG GROUP CREATE TRIGGER CREATE MATERIALIZED VIEW LOG ON B CREATE INDEX LOB LOB STORE AS C CREATE VIEW CREATE MATERIALIZED VIEW COMMENT ON TABLE ON COMMENT ON COLUMN ON CREATE SYNONYM DBMS_REFRESH MAKE DBMS JOB SUBMIT PL SQL CREATE PROCEDURE CREATE FUNCTION CREATE PACKAGE CREATE PACKAGE BODY CREATE TYPE CREATE TYPE BODY GRANT ON TO AUDIT ON BY v4 2 3 11 PLUMSIX Co Ltd
159. SQL Loader make bat _make bat BLOB CLOB NCLOB v4 2 3 79 PLUMSIX Co Ltd 85 QUERYVAR 92 B QUERYFIX 91 QUERYVAR 92 Ei QUERYFIX 91 A FBQSCN 5 DBMS FLASHBACK ENABLE AT SYSTEM CHANG
160. X 1 ox CANCEL Oracle Database 11g 2 11 2 v4 2 3 128 OPLUMSIX Co Ltd 2 CRD 1 26 No 1 MTU DB env bat INPUT userid crd USERID input 2 MTU envbat OUTPUT dstinfo crd
161. 1 I O 0 PARALLELISM 90 2 1 2 PARALLELISM 1 10 20 LISTEXCPT S LISTTABLE OS 32767 30
162. 12 4 1 MTU xla 12 4 2 QikExp bat 125Releadi Eo FA m NO A E 12 116 12 8 4 117 128 ConsDisable 117 12 8 2 GonsErnable T3 HE CS SA RC 118 12 8 3 GetFkrb LL 119 12 8 4 GetTbIP 120 12 8 5 GetTbIN 4 121 12 8 6 GetPIsP Dee ete tdt RE p 121 12 8 7 GetPlsN 44 122 v4 2 3 5 PLUMSIX Co Ltd 13 Unicode ESI 124 14 x64 Windows E Di 125 A a 127 15 1 CRD e488 127 RU NEU ENS 128 5 62 N02 E sss ctore A E CULLEN 129 UM LE 130 M 16 1 16 2 UNRECOVERABLE ETAPA S SE PONTI nct 135 18 138 19 STREAM_LOCATOR
163. 2 2 1 b 2 2 PUBLIC b v4 2 3 21 OPLUMSIX Co Ltd diff UNIX fc Windows SORTING 96 SORT_AREA_SIZE 96 E OS
164. Oracle Database 11g Enterprise Edition Release 11 2 0 1 0 64bit Production With the Partitioning OLAP Data Mining and Real Application Testing options SYSTEM xxxxx xxxxxx C0 xxxxxxXXxxX G xxxxxxxxx TI I xxxxx YYYY MM DD HH MI SS xxxxX G gt XX XXX kbytes kbytes IE sys TU SUC C XProgramDataYPLUMS I XXmtu 4 2Yx86 gt GetNativeSystemlnfo API 16 http msdn microsoft com en us library windows desktop ms724340 v vs 85 aspx v4 2 3 100 OPLUMSIX Co Ltd
165. SQL Loader 1096 Oracle8 SQL Loader VAR 10 RECOVERABLE USUALPATH 99 UNRECOVERABLE LOAD UNRECOVERABLE RECOVERABLE RECOVERABLE LOAD UNRECOVERABLE SQL Loader
166. 46 Bolt 47 8 9 R R FTV 47 Sd aa V 48 FACIAR Ii BINNEN 52 CAR E n i s MR ERE 52 ONERE eo 52 9 1 2 um ccm MM MEM 53 D LI E 54 CE BI escudo dpt EL E 55 9 1 5 RR BIET ARRA UD EE BRE MIO s Cb et bu eR ba dud 56 9 1 6 57 9 1 7 58 9 1 8 SR MM ME M SS 59 ON Amm qr foe anqa E A 60 9 2 9 2 1 9 3 63 s ic E 63 64 9 4 aP ARE d RR Rt 64 9 4 2 9 4 3 IM RCM 66 ROR R 66 ER a M mM 67 67 m ss 69
167. B m X 00 ds 4 Windows 4 Windows PLUMSIX PLUMSIX MTU E 72507 A VES g MTU v4 2 64 bit BRI 2014 02 28 18 29 274 24 Windows Serv TTA MTU v4 2 xx bit ou 0 PLUMSIX MTU v4 2 64 bit v MTU v4 2 64 bit ERRO 2 Boro s_hirayama vboy g GetMeta 2014 03 0 Query
168. REDO log file sync 16 1 set verify off define priv_kb 0 column format 999 999 999 heading Current new value PRIV column format 999 999 999 heading Diff KB select ss value power 1024 1 as CkB Ss Value power 1024 1 amp PRIV KB as DkB from v statname sn V sysstat ss where sn name redo size and ss statistic sn statistict ReLoad Current kB Diff KB 1 512 073 595 899 Reload Redo
169. 9 52 6 5 UnLoad Query 1 42 9 32 v4 2 3 33 PLUMSIX Co Ltd UnLoad D XU where orderby group by Query Windows API 64 16EB
170. r Oracle FPNUMFMT 83 MTU Quick Export 1 2 YYYY MM DD HH24 MI SS YYYY MM DD HH24 MI S8 YYYY MM DD HH24 MI SS YYYY MM DD HH24 MI SS XFF YYYY MM DD HH24 MI SS TZHTZM YYYYAW DD 24 41 55 XFF LONG 1000 TZHTZM p 1000 B 9999 99999999999999999 n 99999999999999999999999 Multi threaded Unloader MTU 11 MTU Microsoft Excel Book1 E PRAG Oo 7 50 AID Adobe PDFB D cg R FEIKE ij MS Pdv 5 11
171. v4 2 3 98 PLUMSIX Co Ltd MTU MTU PRIORITY_CLASS 91 NORMAL HIGHEST IDLE IDLE BELOW NORMAL NORMAL ABOVE NORMAL HIGH 1 REALTIME 16 LOWEST 2
172. 1 Oracle 2 PATH OCL DLL PATH C Program Files PLUMSIXWntu_4 2 C Program Files x86 Oracle jre 1 3 1 bin C Program Files x86 Oracle jre 1 1 8 bin C Windows system32 C Windows Windows System32 Wbem C XWindowsYXSystem32XW indowsPower She I Xv1 0X rcImportOciLibrary psOciCommon c 708 rc0ciSvc cOciSvc c 1298 mtu c 550 Oracle Client Oracle Server PATH oci dll oci dll Oracle x64 Windows 32 bit MTU 32 bit Oracle Client Oracle Server
173. C XProgramDataYPLUMSIXXmtu 4 2Yx86 instal Multi threaded Unloader version 4 2 12 1 APLDDTO1 Executing ORA 00955 rcStmtExecute cOciStmt c 540 rcExecDefineAndFetch cOciStmt c 1054 rc0ciStmtVa c0OciStmt c 1406 rc0ciStmtList cOciStmt 1474 rcInstall rcInstall c 559 AM 1 00 mtu c 1004 C ProgramData PLUMSIXWntu_4 2 x86 gt 10 2 2 68 Install ORA 01031 C ProgramData PLUMSIXWmtu_4 2Yx86 instal 1 Multi threaded Unloader version 4 2 12 1
174. Env bat 11 70 BO 2 Envbat GetPlsN bat 3 C XProgramDataYPLUMS I XXmtu 4 2 x86 gt GetPlsN Multi threaded Unloader version 4 2 12 1 2 v4 2 3 123 PLUMSIX Co Ltd PL SQL output plsn txt Z 25 0 18 ffr BE T ER A 2 25 0 49 2 62 0 00 D 62 0 11 RO SET 65 54 103 kbytes 1 35 1 21 kbytes 1 12 CECI G YProgramDataYPLUMSIXYmtu 4 2Yx86 a OUTPUT FILEPLSN 81 b APLDDT02 c 500
175. Many Core CPU 19 STREAM_LOCATOR 142 B 5 MTU IPC e 19 STR
176. 1 1 1 MTU TH a d
177. DATE_MASK 77 to_date c 18 UnLoad 104 d STREAM_LOCATOR 98 E ENCLOSER ENCLOSER2 78 E 1 1 1 1 Oracle BULK_SIZE 75 FEEDBACK 80
178. LOCALE_SDAYNAME M 1 0 MM 1 0 MMM 3 1 2 LOCALE_SABBREVMONTHNAME MMMM 1 2 LOCALE SMONTHNAME y 2 1 0 yy 2 1 0 yyy 4 gg CAL SERASTRING gg W
179. PL SQL SRC_USER gt 1 NMENCLS 87 SRC USER NMENCLS NMENCLS scott scott SCOTT ScOtT ScOtT SCOTT SCOTT SCOTT SCOTT 30 LOB OUTPUT 89 STREAM_LOCATOR 98
180. 16 Information ROWID 16 ROWID v4 2 3 150 OPLUMSIX Co Ltd SORTING 96 ROWID_SPLIT_MIN_SIZE 0 Warning SORTING ROWID_SPLIT_MIN_SIZE 0 ROWS 94
181. SQL Plus DEPENDENT 77 El PL SQL PL SQL PL SQL v4 2 3 29 PLUMSIX Co Ltd MVIEW MVIEW LOG LOB STORAGE SQL COMPRESS 76 H SQL 7 1 GRANT ANY ROLE GRANT ANY PRIVILEGE S
182. 11 70 2 Envbat GetTbIN bat 3 C XProgramDataYPLUMS I XXmtu 4 2 x86 gt GetTbIn T12 1 100 output tbIn txt Z 4 0 00 B 4 1 28 0 00 A 28 0 07 7 5 42 kbytes 0 11 0 76 kbytes 0 14 EAr CECE C XProgramDataYPLUMSTXXmtu 4 2 x86 gt a OUTPUT FILETBLN 82 b APLDDT02 c 500 FEEDBACK 0 c d
183. 14 ABC C C n n s s D E i n S a a b b 1 e e ALTER DEST e iR AUXILIARY DEST e iR BIND SIZE 20 BULK SIZE oe o o o 1000 CHARSETFORM iR CHARSETID 0 CLIENT ID o o 0o O O MIUCLENT v4 2 3 71 PLUMSIX Co Ltd CMNTLVL COMPRESS CONSISTENT DATAEXT DATE MASK DB FILE MULTIBLOCK READ COU NT DEPENDENT DFILE ALT DIRS DIRALIAS DISCRETE DST INFO EMBED COLUMN NAME ENCLOSER ENCLOSER2 ENDTERM EVENTS EXEC LOAD EXEC PLUS EXTNAMEBLOB EXTNAMECLOB EXTNAMESQL FBQSON FBQTIME FEEDBACK FILEBIND FILEEXCPT FILEFIXED FILEFKRB FILELOG FILEMETA FILEPLSN FILEPLSP FILESIZE FILETABLE FILETBLN FILETBLP FILETRACE FINDSTRCMD FPNUMFMT GETEXTTBL INPUT IO OVERLAP SCALE LISTEXCPT LISTFIXED v4 2 3 s D i s a b o Op 72 1 True True lt gt YYYYMMDDHH24MISS 128 true iR ALIAS1 true scott tiger iR iR true lt gt sqlldr sqlplus blo clo sql lt gt lt gt 10 bind dat excpt dat fixed dat fkrb sql lt gt meta sql plsn txt plsp txt 2000M table dat tbln txt t
184. FEEDBACK 0 c CTRL C FEEDBACK CAN e 2 OUTPUT 89 v4 2 3 107 PLUMSIX Co Ltd 12 4 12 4 1 MTU xla 1 7 1 MTU xla Addins call platform bat EXEC DIRSMTU xla APPDATA WMicrosoft addIns 2 Microsoft Excel 3 Office Xp
185. FEEDBACK 0 c d PL SQL PL SQL OUTPUT FILEPLSN PL SQL v4 2 3 124 PLUMSIX Co Ltd 13 Unicode MTU Unicode UnLoad Query CHARSETID 75 ID CLOB CHAR VARCHAR2 NCHAR NVARCHAR2 LONG LOB
186. mtu exe PsPas cer PsPasCli dll PsPasCom dll env bat EXECUTABLE mtu x86 exe mtu exe 9 52 ED snv bat EXECUTABLE mtu exe mtu_x86 exe env bat v4 2 3 38 PLUMSIX Co Ltd 8 v3 06
187. 0 1 9 RI C ProgramData PLUMSIXWntu_4 2Yx86 SRC_USER STATUS ENABLED Not NULL ALL_CONSTRAINTS ALL_ TRIGGERS STATUS define 0BJOWNER SRC_USER
188. 2 GetMeta bat 3 C XProgramDataYPLUMS IXXmtu 4 2 x86 gt getmeta Multi threaded Unloader version 4 2 D 1 ve output meta Ht RZ A Z A 1 A PK AK FK v4 2 3 6 25 172 4 22 2
189. 9 1 8 60 9 1 7 2 2 RIEF 28R L L
190. LET MTU EOF MTU ERROR PIPE NOT CONNECTED MTU MTU Code 0xe8 Mse ConnectNamedPipe 29 DisconnectNamedPipe v4 2 3 147 OPLUMSIX Co Ltd MTU MTU IPC
191. PGA pga_aggregate_target gt 0 PL SQL PL SQL 16 C 16 SQL PL SQL 16 v4 2 3 96 PLUMSIX Co Ltd 15 14 PL SQL 13 PL SQL 12 1
192. as 84 MIN B EK SIZE ete a a a maq ua aaa guau 85 e t tipa lene mu n det ente dde teen c a ptr n Al veces 85 MINIMUM FREE SIZE I eh P e ee Pto bu aei ane e 85 MNGSOCROUT et ee e EO RE OU pedi due E41 85 DB FILE MULTIBLOCK READ COUNT eese u tentent tentent titt uu a n 86 NMENGLES 3 t EE RU tL EUR ete CO ete UO IRR 86 NOBYTEORDERMHARNK dede te een ei ic sau eb t t edi 86 NUM ASYNGEOBS OO 86 NUMIROWSL 87 2 EE ER 87 NU MDAYS AUDIT etat OMS etae 87 OETIMIZERIRINTSELOOLOTOTROLT 5 88 OPTIMIZER MODE eeiam baee obl A 88 OUTPRUT MEE 88 OVERLAP BU EFER LENGTH e ipte mta YR eto e ed e Dep Oleo reat tra aa sana 88 PARTITIONING p eit Ho te Rte et Sis 88 PARALLEEISM recreate ttt Reden DP dtc p ADR au u tes 89 ot repetita tatit tu rece pte tcp tu tet 89 idc eaedem ilte Ped dtu Ree dad Rod dee Go es 90 ERINiGO DEAN 90 PRIQRITY GLASS EK KRK KK 90 QUE 90 QUERYVAR x six S u RR RU u an dtm qb bu NER RE 91 IIR EE ducent de PRU ete u ua pee dede Eee iust 92 iota o
193. net start Performance Logs amp Alerts 24 2 1 v4 2 3 164 PLUMSIX Co Ltd MTU mtu_parf log logman create counter mtu parf log c XLogicalDiskYAvg Disk bytes Mr ite XLogicalDiskYXAvg Disk XLogicalDiskYAvg Disk Write Queue Length XLogicalDiskYXDisk Write Bytes sec XProcessor Total Processor Time si 00 01 00 sc 1440 b 2013 7 5 15 50 o 31 163 si sc b 2313 7 5 15 50 1 1440 I2 Fi EL lt SE r L L o
194. OS Windows 24 1 MMC GUI 24 2 164 Windows
195. 2 1 O 1 PARALLELISM 0 32 0 1 CPU 1 2 LOB Unload Query 2 POST_REP_EXEC_PLS PL SQL
196. N Q 12 5 Reload 1 43 Enba Env bat 11 70 2 Envbat Reload bat 1 12 6 116 3 G YProgramDataYPLUMSIXYmtu 4 2Xx86 reload Multiplexed Process eXecutor version 1 06 Copyright c 2007 2010 Plumsix Co Ltd All rights reserved Parallel degree is 2 Processes will run with BELOW NORMAL priority class Show window mode is 6 sqlldr sqlplus will be executed in parallel Returned value from findstr will be ignored Startup directory is output STDOUT from the child processes will be stored to stdout log Reading make bat Waiting 1 10 completed 3 33s el
197. NMENCLS ALTER_DEST 30 Oracle SQL 2 Oracle SQL NOBYTEORDERMARK 8 CHARSETID 75 UTF 8 BOM SDF LOB BOM BOM BYTEORDERMARK NOCHECK NUM_ASYNCLOBS KED 0 LOBFILE LOBFILE
198. APLDDTO1 _ Exeouting v4 2 3 174 PLUMSIX Co Ltd ORA 01031 rcStmtExecute cOciStmt c 540 rcExecDefineAndFetch cOciStmt c 1054 rc0ciStmtVa cOciStmt c 1406 rc0ciStmtList cOciStmt c 1474 rcInstall rclnstall c 559 0 26 mtu c 100 C ProgramData PLUMSIXWntu_4 2 x86 gt ay SQL SQL Plus 8 39 ORA 01950
199. Windows Shift JIS MERGE_LOBS_ INTO_SDF 85 SDF NLS_LANG CHARSETID UTF 16BE BOMA NOBYTEORDERMARK 87 23 Unicode CHARSETID 0 N CHARSETID 873 AL32UTF8 CHAR VARCHAR2 NCHAR UTF 8 NVARCHAR2 LONG NLS LANG BOM NOBYTEORDERMARK 87 E CLOB CLOB NLS_LANG CLOB UTF 8 BOM NCLOB CLOB UTF 16BE BOM NLS_LANG Shift JIS 9 UTF 16BE BE Big Endian 2 Windows CHARSETID 0 832 JA16SJIS
200. FILEBIND 80 key value SHOWSTMT 95 TRUE GetMeta ORA 01436 CONNECT BY GetMeta 43 DelCircular sql GetTbIN
201. GetLogicalProcessorInformation 7 API c xxxxxxx 16 Install UnLoad Query GetMeta SQL ConsDisable ConsEnable GetFkrb GetTbIP GetTbIN GetPlsP PL SQL GetPlsN PL SQL d ID Oracle ID CHARSETID 75 NLS_LANG
202. input drop_all_apldd sql DBA drop_all_apldd sql C ProgramData PLUMSIX mtu_4 2 x64 gt sqlplus SYSTEM XXXXXXX XXXXXXXXXXXXXX SQL Plus Release 11 2 0 1 0 Production on 3 9 16 43 11 2012 Copyright c 1982 2010 Oracle All rights reserved Oracle Database 10g Enterprise Edition Release 10 2 0 3 0 64bit Production With the Partitioning OLAP and Data Mining options SQL input drop_all_apldd sql PACKAGE SYSTEM APLDDPO1 was dropped TABLE SYSTEM APLDDTO1 was dropped TABLE SYSTEM APLDDTO2 was dropped TABLE SYSTEM APLDDTO3 was dropped TABLE SYSTEM APLDDTO4 was dropped PL SQL SQL Plus exit SQL gt exit Oracle Database 10g Enterprise Edition Release 10 2 0 3 0 64bit Production With the Partitioning OLAP and Data Mining options C ProgramData PLUMSIXWntu_4 2 x64 gt 10 3 1
203. LOBFILE PARTITIONING 89 gt _R9999999999 C9999 gt gt gt _R9999999999 C9999 gt CLOB NCLOB EXTNAMECLOB 79 B BLOB 286 EXTNAMEBLOB 79 9 1 v4 2 3 156 PLUMSIX Co Ltd 10 R C 23 1 3 LOBFILE PDF dat LOB LOB LOB fil LOB LOBFILE
204. PDF dat LOB PDF SDF A LOB LOB LOB LOB LOB LOB IS NULL NONE LOB IS NOT NULL have LOB HIS NULL Empty SDF or PDF NONE PDF 00000000221 have 00000000223 have NONE 00000000224 have NONE 00000000227 have have 00000000226 have have 00000000229 have NONE 000000002310 NONE have 00000000222 NONE have 00000000225 have have 00000000228 NONE have
205. cPool 441 rcPool cPool c 526 rc0ciSvc c0ci Svc c 1327 0 20 mtu c 981 C ProgramData PLUMSIXWntu_4 2 x86 gt alert log ORA 12560 TNS C ProgramData PLUMSIX mtu_4 2 x86 gt install Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved IPC 0RA 12560 TNS Error IPC ORACLE SID rcAttachToServer psOciCommon c 885 rc0ciSvc cOc i Svc 1194 oa 0 06 mtu c 988 C XProgramDataYPLUMS I XXmtu 4 2 x86 gt IPC Oracle Error
206. File Type of Backup Required Name RMAN gt exit 9 v4 2 3 185 PLUMSIX Co Ltd 17 TAF MTU TAF Oracle Database Client OCI TAF 136 5 TAF 1 2 NLS DATE FORMAT 5 TAF
207. v4 2 3 64 PLUMSIX Co Ltd 9 4 3 9 4 1 PSPASCLLDLL OK
208. 179 Warning LONG LONG RAW So 180 27 4 SQL Loader 181 ORA 02359 7 4 274 1021 17 181 SQL Loader 510 xxx dat xxx SQL Loader 555 M DEC 181 ORA 06564 ALASI a 181 215 COMO SE RENT A RP 182 DID M QNNM MEI QM 182 182 DENRA Re CLP 183 RECEN 183 v4 2 3 7 PLUMSIX Co Ltd 28 2 Not Null 183 rc ELM 184 V Pa Da ao ESAV RE 185 29 1 Unboad CSV nN lt 1 185 29 BHL scott vut T 185 hem nU 185 29 2 UnLoad 446E E RERO Son sosta eue MEL LC C UE 186 ML OH dl are qusqa 186 2022 9 IZA die upa aaa p LE E ELI E LLL 186 29 3 UnLoad eco SEMEL ote
209. FILESIZE OS lt gt _999999 DATAEXT 77 gt 999999 0 6 DISCRETE 77 FILESIZE 2000M 2000 SQL Loader SQL Loader 2 31 1 1 lt 1 3 BULK SIZE 75 E
210. MTU WaitNamedPipe ERROR FILE NOT FOUND MTU PARALLELISM 90 2 MTU MTU PARALLELISM 3
211. IP ORA 01034 ORACLE not available C ProgramData PLUMSIX mtu_4 2 x86 gt install Multi threaded Unloader version 4 2 2003 Plumsix Co Ltd All rights reserved xxxx system Oracle Database 11g Enterprise Edition Release 11 2 0 1 0 64bit Production With the Partitioning OLAP Data Mining and Real Application Testing options c0OciSes FIFO ORA 01034 ORACLE not available v4 2 3 172 PLUMSIX Co Ltd ORA 27101 shared memory realm does not exist Error rc0ciSes cOciSes c 218 rc0ciSesInPool cOciSes c 285 rcAddOrDelItems cPool c 358 rcPulseOrWaitForEvent cEvent c 247 Information szItemType c0ciSes iMaxItems 0 iNumFree 0 rCtx iDifference 1 rcChgNumItemsPool 0
212. 6 8 GetMeta CREATE SEQUENCE START WITH ALL_SEQUENCES LAST NUMBER NEXTVAL CREATE SEQUENCE CACHE 6 9 MTU xla Excel Excel v4 2 3 36 OPLUMSIX Co Ltd 7 v4 2
213. GUI 24 2 3 stop v4 2 3 166 PLUMSIX Co Ltd logman stop mtu parf log 24 2 4 delete logman delete mtu parf log v4 2 3 167 PLUMSIX Co Ltd 25 MTU 32 1 8 8 47 XuUsername passwor d gt Gdb al ias
214. L e Bi CPU CPU 3 CPU v4 2 3 CPU CPU Hik CC ES 58 PLUMSIX Co Ltd
215. XML DB UnLoad GetMeta 6 3 UnLoad Query 10 UnLoad lt gt _DEPS sqal create index tablespace lt gt GetMeta tablespace lt gt compress 8 https support oracle com v4 2 3 32 OPLUMSIX Co Ltd 33 194 6 4 v4 1
216. release txt 1 No 1 MSI Microsoft Software Install Windows OS e 39 B v3 06 ZIP 2 x64 Windows x64 x86 x64 Windows Oracle Client for Windows 32 bit WOW64 x86 14 x64 Windows 126
217. 28 1 EMP EMAIL Not Null LOAD INFILE EMP VAR 10 INTO TABLE EMP TRUNCATE REENABLE FIELDS TERMINATED BY EMPNO DECIMAL EXTERNAL 5 CHAR 10 ENCLOSED BY JOB CHAR 9 ENCLOSED BY MGR DECIMAL EXTERNAL 5 HIREDATE DATE 16 YYYYMMDDHH24MISS ENCLOSED BY SAL DECIMAL EXTERNAL 9 COMM DECIMAL EXTERNAL 9 DEPTNO DECIMAL EXTERNAL 3 EMAIL CONSTANT dummy hq acme a a CONSTANT Not Null 28 2 Not Null EMP O JOB Not Null LOAD INFILE EMP VAR 10 INTO TABLE EMP TRUNCATE REENABLE FIELDS TERMINATED BY EMPNO DECIMAL EXTERNAL 5 ENAME CHAR 10 ENCLOSED BY JOB CHAR 9 ENCLOS
218. Bytes sec kbytes Processor Processor Time 1 0 10096 CPU v4 2 3 163 OPLUMSIX Co Ltd ae lt 5 OK LogicalDisk z Avg Disk Bytes Write Idle Time Avg Disk sec Write Avg Disk Bytes Read Disk Write Avg Disk Bytes Transfer 9 Disk Bytes Write Avg Disk sec Write H FE A V O W H am E e As
219. CHARSETID NLS LANG NCLOB NCLOB clo UTF 16BE7 BOM CLOB CLOB clo CHARSETID NLS LANG CHAR VARCHAR2 NCHAR NVARCHAR2 LONG CHARSETID NLS LANG AL32UTF8 UTF8 UTF 8 NOBYTEORDERMARK 87 BOM BOM LOB NLS LANG
220. create table drop table truncate table drop table DDL DDL v4 2 3 11 PLUMSIX Co Ltd 3 v4 2
221. BELOW_NORMAL 1 NORMAL ABOVE_NORMAL 1 HIGHEST 2 TIME_CRITICAL IDLE BELOW_NORMAL NORMAL ABOVE_NORMAL HIGH 15 REALTIME 31 USERID MTU Env bat MTU GetFkrb bat GetMeta bat GetPlsN bat GetPlsP bat GetTbIN bat GetTbIP bat Install bat QikExp bat Query bat UnLoad bat 8 8 47 ED USUALPATH gt
222. MTU xla Microsoft 8 Excel Query Query QikExp bat Windows S Query Query 4 5 2 ConsDisable ConsEnable
223. a i e a r E r 78 EVENTS cte ettet au tto t AE 78 EXEC LOAD cL 78 EXEGBEUS Ko 78 EXINAMEBEOB EE 78 EXTNAMEGCLOB L u a eee he a u qa us u uu u a uuu 78 L ua asla 79 FBQSGCN eu DRM 79 cit ie b tet P e RE Eae nt Uer edicit 79 FEEDBACK ElLEBIND e RE ES a FILEEXCPT FILEFIXED FIEEEKRB RSEN M 80 gH po 80 EE EE 80 ict ette dete due eI eed d b eR ua us a Sau sani 81 eO dee ot td ion t Root EE 81 EIBETABEE de eate t eene lebe let e bii etu RS 81 PIKET BLN ELLE Eae ARE M Nut ER RE I Uo Id ORE a 81 EE 82 FIEETRACE desi 82 EINDSTROMD te ei ot e bt b ad EE 82 v4 2 3 3 OPLUMSIX Co Ltd GETEXTTBL E ERR RET 82 IN 82 eee tn mu u S etie d e PR RU 83 ST 83 ua aha aa ab 83 SEEAEBEE MP S 83 LOADMETHOD LONGTRANSIT MAXLONGSIZE MERGE LOBS INTO SDF osea esent decet uuu au a ee cpu ua a aa SAN 84 METADIV u
224. 1 UNRECOVERABLE REDO REDO Oracle REDO REDO SQL select from emp select from emp arts 5 b ss bs 0RA 01578 3 51 Oracle ORA 01110 3 D ORACLE ORADATA ORCL USR1 DBF ORA 26040 NOLOGGING SQL SELECT substrb OWNER 1 14 as OWNER Substrb SEGMENT NAME 1 30 as SEGMENT NAME SEGMENT TYPE EXTENT ID FROM DBA EXTENTS WHERE file_id 3 AND 51 BETWEEN block id AND block id blocks 1 SEGMENT NAME SEGMENT TYPE EXTENT ID
225. Microsoft Microsoft Cor Microsoft Cor Microsoft Cor B Microsoft Cor 099 2522 5 Microsoft Cor 125223 Microsoft W Microsoft Cor E PEL mt Microsoft Cor Microsoft Cor Microsoft Cor 3 Microsoft Cor E Microsoft Cor Microsoft 7 5 3 Microsoft 9 Microsoft Cor Microsoft Cor M n Microsoft Cor Bh Microsoft Cor 9525 2522 5 Microsoft Cor 2 Microsoft
226. Windows API GetTimeFormat 4 h 12 1 0 hh 12 1 0 H 24 1 0 HH 24 1 0 m 1 0 mm 1 0 5 1 0 v4 2 3 143 PLUMSIX Co Ltd SS 1 0 t 1 A P tt AM PM E 19 2 pc pipe
227. 1 O MTU MTU 3 MTU stdoutlog lt stderrlog lt stdoutlog _stderr log OUTPUT 89 PARAL
228. AUXILIARY_DEST 74 DFILE_ALT_DIRS 77 DSTINFO v4 2 3 142 PLUMSIX Co Ltd DATAEXT dat ctl D Windows GetDateFormat 4 d 1 0 dd 1 0 ddd 3 LOCALE SABBREVDAYNAME dddd
229. DB DSTINFO output 15 1 1 No 1 input D J 87 00 5A lt nut Te oss QU lt e ross input E gt ES A d m output I Ji qryvar gt 42 5 amp j Subversion amp C 3 T MH userid crd user id T crd T crd S 2
230. SCOTT APLDDTO1 Executing 0 00955 rcSqlStmtExecute cOciStmt c 448 rcExecDefineAndFetch cOciStmt c 1131 Error offset R 1 13 Line No Statement je 1 create table APLDDTO1 table name varchar2 30 data fmt number 2 default 0 not null constraint APLDDTO1_PK primary key table name constraint APLDDTO1_CKO1 check data fmt in 0 1 8 pctfree O storage initial 128k next 128k pctincrease 100 rc0ciStmtVa c0OciStmt 1505 rc0ciStmtList cOciStmt 1574 rcInstall rcInstall c 567 0 25 mtu c 487 v4 2 3 50 PLUMSIX Co Ltd C XProgramDataYPLUMS IXXmtu 4 2Yx64 USERID
231. UNLIMITED TABLESPACE SQL Plus 8 39 27 2 MSVCR120 dl v4 2 3 175 PLUMSIX Co Ltd mtu exe MSVCR120 dI Way MTU Microsoft 6 1 31 MTU Error
232. ENDTERM 5 CSV TERMINATOR TRAILING NULLCOLS STREAM_LOCATOR 98 SQL Loader RECLENGTH 93 A EVENTS alter sesion set events STRING XO STRING 1 512 MTU Oracle
233. Mm 9 2 52 1 1 9 1 52 9 2 1 v4 2 3 62 OPLUMSIX Co Ltd RJT ROZ a
234. nnnnnn 4 000001 999999 DFILE_ALT_DIRS 77 B FILESIZE 82 1 X ctI LOAD INFILE v4 2 3 151 PLUMSIX Co Ltd 21 Query QUERYFIX 91 A QUERYVAR 92 PARALLELISM 90 select from emp where job ANALYST and hiredate gt to date b hiredate yyyy mm dd select from emp where job CLERK and hiredate gt to date b hiredate yyyy
235. v4 2 3 105 PLUMSIX Co Ltd SKIPSCR 96 g _conn sql sql SQL Plus CONNECT x DSTINFO 78 B h disable deps sql STATUS DISABLE INSERT DELETE MNGSCROUT _make bat i _make bat Windows j parOtxt SQL Loader
236. select constraint_name constraint_type status from all_constraints where owner amp OBJOWNER select trigger trigger type status from all triggers where owner amp OBJOWNER 12 8 2 ConsEnable 1 43 Enba Env bat 11 70 2 Envbat ConsEnable bat 3 C ProgramData PLUMSIXWmtu_4 2 x86 gt ConsEnable Multi threaded Unloader version 4 2 v4 2 3 119 PLUMSIX Co Ltd 112 1 100 9 1 2 41 7 87 L L G YProgramDataYPLUMSIXYmtu 4 2Yx86 SRC_USER STATUS DISABLED
237. MMC PLUMSIX Co Ltd OK v4 2 3 5 S E 5 m t
238. 2 TERMINATOR 98 A ENCLOSER ENCLOSER2 78 Microsoft Excel copy amp paste set EMBED_COLUMN_NAME 0x09 0x22 EMBED COLUMN NAME AUXILIARY_DEST 74 DFILE_ALT_DIRS 77 B RECLENGTH 93 A ENDTERM 79 DISCRETE 77 CHARSETID 75 CHARSETID 873 871 utf 8 utf 8 ENCLOSER ENCLOSER2 v4 2 3 78 PLUMSIX Co Ltd
239. FEEDBACK 0 c CTRL C FEEDBACK CAN OUTPUT 89 C ProgramData PLUMSIX mtu_4 2 x86 gt dir output C HDO1 G 1431 E578 C borland USER mtu 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 2008 08 01 lt DIR gt lt DIR gt T 304 DEPT ctl 160 DEPT dat 697 DEPI_DEPS sql 631 EMP ctl 869 EMP dat 651 EMP_DEPS sql 303 SALGRADE ctl 182 SALGRADE dat 318 SALGRADE DEPS sql 910 TESTI 245 TESTI dat 1 195 IEST18_DEPS sql 104 PLUMSIX Co Ltd 2008 08 01 592 TE
240. SQL Loader TRUNCATE TABLE TRUNCATE Unload Query SQL Loder MTU
241. 4Youtputwdst_info cre U l U U IscoTT P P Tr asus BAD LM B 7 4 NN C SYSDBA A C SYSOPER O 4 NN C SYSDBA A C SYSOPER O CANCEL CANCEL Oracle Database 11g SET SEC CASE SENSITIVE LOGON TRUE OK 15 2 CRD mkcrd exe CRD MTU SQL Plus SQL Loader env bat
242. DFILE ALT DIRS 77 OUTPUT AUXILIARY DEST DFILE_ALT_DIRS v4 2 3 139 PLUMSIX Co Ltd 1 1 6 NON_PART_LARGE_TABLE dat NON_PART_LARGE_TABLE_000001 dat 6 1
243. IOPS 9 e PARTITIONING 89 A 10 LOB LOB LOB e MERGE LOBS INTO SDF 85 11
244. 8D 0M XY3X7 LINIP QGONL 7 J3F5 1 o CPU 0 546 CPU 2 RHED 8 06 50 02 96 0 EG th 0 ES seo nET authenticate dat
245. 13 Unicode 125 sql STATUS DISABLE INSERT DELETE d PARTITIONING 89 e PARTITIONING 89 f blo clo BLOB CLOB NCLOB LOB EXTNAMECLOB 79 EXTNAMEBLOB 79
246. Error Win32API Code 0x5 MSg rcChkWin32Api rcChkWin32Api c 30 Error output meta sql rcFile cFile c 408 rcGetMeta psGetMetaYrcGetMeta c 633 0 25 c 1004 C XProgramDataYPLUMSTXXmtu 4 2 x86 gt 3 Error Win32API Code 0x70 Msg C XProgramDataYPLUMSIXXmtu 4 2Yx86 unload Multi threaded Unloader version 4 2 12 1 B qo os output TableName 3 NumRows Elapse Rows s Bytes kB s Len Error output STATS BG_EVENT_SUMMARY dat dwAddNextExtent cFile c 74 Error Wi
247. 11 70 2 Envbat GetFkrb bat 3 C ProgramData PLUMSIX mtu_4 2 x86 gt GetFkrb Multi threaded Unloader version 4 2 1 2 NR y 7 output fkrb sql Z 22 0 00 B 0 11 0 18 0 16 v4 2 3 120 PLUMSIX Co Ltd PK AK FK kbytes kbytes IER CECI 1 5 11 49 0 26 2 69 0 10 C XProgramDataYPLUMSTXXmtu 4 2Yx86 a OUTPUT FILEFKRB 81 b BULK_SIZE FEEDBACK FE
248. c XProgramDataXPLUMSTIXXmtu 4 2Xx64X inputX drp prod sql c ProgramData PLUMSIX mtu_4 2 x64 input cre pub syn sql c ProgramData PLUMSIX mtu_4 2 x64 input drp pub syn sql SR F Z 5 T 5 28 kbytes 2 51 0 69 kbytes 3 64 c XProgramDataYPLUMS I XXmtu 4 2 64 gt installbat ORA 00955 Oracle Database 10g Enterprise Edition Release 10 2 0 3 0 64bit Production With the Partitioning OLAP and Data Mining options xxxXXXXXXXXXXX DEDICATED D 4013432 TH 2012 03 09 16 23 55
249. select any table select from v session where audsid I D audit session create session 91 select from dba audit session where sessionid I D OS JEDER 0 SRC_USER 97 A SELECT ANY TABLE SYS V SESSTAT X V SESSION V_ STATNAME SELECT BULK_SIZE 75
250. 14 v4 2 3 86 PLUMSIX Co Ltd Not NULL DB FILE MULTIBLOCK READ COUNT NMENCLS KD NMENCLS SRC_USER 97 Ei ALTER_DEST 74 B
251. 27 P W envbat USERID MTU SYSTEM MANAGER o111utf8 Guserid crd DST INFO SQL Loader SQL Plus SCOTT TIGER o111utf8 dst info crd DBB CRD MTU INPUT 83 SQL Plus SQL Loader OUTPUT 89 UNC v4 2 3 181 OPLUMSIX Co Ltd 16
252. GetTbIP bat Install bat mtu_prompt bat MTU Platform bat QikExp bat Microsoft Excel QikExp dat QikExp bat Query bat ReLoad bat Uninstall bat UnLoad bat input cre pub syn sql Install input _drp_prod sql Install input drp pub syn sql Install inputXbind dat inputXdrop all
253. i Jes ie 26 611053 500 1 4BVKO 30180 3 e 9 TEMO si L BW0S3 RLOQT 500X1 4BVKO 30L80 3 D51DxX 5141Y D50HA OFXHU 3U4UP 2 AS5L3E JE3CF PLMI8 1AKPN MRAXC N 21 00 35 3000 5 CPU CPU 2 CB 50 02 96 33 194 B UE result 1 host albatross plumsix co jp msg The error occurred during a call to WinHttpSendRequest
254. xxxxxx ORA 01536 C XProgramDataYPLUMSIXXmtu 4 2 x86 gt instal Multi threaded Unloader version 4 2 12 1 2 APLDDTO1 _ Exeouting ORA 01950 xxxxxx rcStmtExecute cOciStmt c 540 rcExecDefineAndFetch cOciStmt c 1054 rc0ciStmtVa cOciStmt 1406 rc0ciStmtList cOciStmt c 1474 rcInstall rcInstall c 559 0 34 mtu c 1004 C ProgramData PLUMSIXWntu_4 2 x86 gt a SQL
255. Sat Aug 23 16 48 16 2008 Warning 1 lock table SYSTEM APLDDTO1 in share mode nowait ORA 00054 NOWAIT 1 13 Sat Aug 23 16 48 17 2008 Warning 2 lock table SYSTEM APLDDTO1 in share mode nowait 0RA 00054 NOWAIT 2 13 Sat Aug 23 16 48 19 2008 Warning 4 lock table SYSTEM APLDDTO1 in share mode nowait 0RA 00054 NOWAIT 3 13 Sat Aug 23 16 48 23 2008 Warning 8 lock table SYSTEM APLDDTO1 in share mode nowait
256. T B TE ESO 5 7 IR Windows m E 2014 01 27 x Multi threaded Unloader v4 2 0 64 bit BR Plumsix Co Ltd Update for Japanese Microsoft IME Postal Code Dictionary Microsoft Corporation 2014 01 27 Update for Japanese Microsoft IME Standard Dictionary Microsoft Corporation 2014 01 27 15 0 1080 Update for Japanese Microsoft IME Standard Extended Dictionary Microsoft Corporation 2014 01 27 15 0 1080 87 7 n 6 v4 2 3 42 PLUMSIX Co Ltd ProgramFiles PLUMSIX mtu_x x
257. UnRegister exe docXIntro MTU pdf docXlicense rtf doc readme_mpx pdf doc readme_mtu pdf doc release txt readme txt doc WP_NewFeature_v40_Allpdf sample demo_vpd sql Virtual Private Database sample GetClobVal sal 4 XMLType sample GetSchema sql 5 gbms_metadata sample LineCount pl sample LineCountP pl sample NamedPipeMulti cpp C sample NamedPipeMultijava java sample NamedPipeSingle cpp Cr
258. 91 DISPLAY SIGN LEADING SEPARATE 7 91 NUMBER BCD 10 NUMDAYS_AUDIT gt 0 S FILESIZE lt 32 0 meta sql 8 Oracle D D OS e OS Oracle e 0 E SYS AU
259. LOBFILE 1 lt NUM ROWS lt 32 LOBFILE LOB 2 LOB v4 2 3 87 PLUMSIX Co Ltd 0 NUM ROWS lt 32 0 1 0 1 NUMBER2BCD 7 COMP 3 10
260. MAXLONGSIZE 85 1000 2 4 6 23 MAXLONGSIZE BULK_SIZE 75 MAXLONGSIZE amp BIND_SIZE 75 E 27 4 SQL Loader ORA 02359 xx xxxxxxXX 1 lt gt bad SQL Loader 51
261. xxxxxx PE ee oct n edm EU Dm DRM M MM D C Ens 174 2123 AA 174 MSVCR120 dll oo ette 174 Error a 175 Win32API Code 0x3 Msg eo ee 175 Error Win32API Code 0x5 Msg ek 4 176 Error Win32API Code 0x70 Msg 176 Query ORA 01008 177 GetMeta ORA 01436 CONNECT BY 4a 178 UnLoad ORA 01466 SEE SS AAE 178 Instant Client ORA 12705 Cannot access NLS data files or invalid environment specified ORA 12705 NLS a ELE 178 273 udi a T T T a 178 Warning 1 178 ConsEnable Warning ORA xxxxx
262. 8 6 46 8 7 46 8 8 47 8 9 EXCEPTION 47 8 10 48 Administrators Users 8 1 V3 06 readme pdf 42 v3 03 readme txt v4 2 3 39 OPLUMSIX Co Ltd 8 2 6 1 31
263. diT MAYt vv Microsoft Q Microsoft Cor 04 9 Microsoft Cor 2 9 Microsoft Cor I Microsoft Cor Microsoft Cor Microsoft Cor 7 E ERN O 2 W BH mlx 25 E iB s 8 4 gt 0 21 4g im 80 Dg 20 0 9 11 29 9 12 00 9 12 30 9 13 08 E D Z 4 9 lt lt m D 162 S 2 gt I I gt PLUMSIX Co Ltd emen M
264. 0 PLUMSDX license dat gt McAfee gt Microsoft Microsoft Help 4 jj PLUMSIX authenticate dat license dat PsPasCli ini gt a Start Menu PLUMSIX Co Ltd 9 1 2 53 9 1 8 60 9 3 9 3 1
265. 23 2 4 SDF LOB SQL Loader LOAD INFILE TEST31 VAR 10 INTO TABLE TEST31 TRUNCATE REENABLE FIELDS TERMINATED BY INTEGER DATA DECIMAL EXTERNAL 11 CLOB DATA LOB FILLER CHAR 4 ENCLOSED BY 77 CLOB DATA LOBFILE CONSTANT TEST31 0002 clo CHARACTERSET AL16UTF16 BYTEORDER BIG BYTEORDERMARK CHECK VARCHARC 10 1000 NULLIF CLOB DATA LOB NONE NCLOB DATA LOB FILLER CHAR 4 ENCLOSED BY 77 NCLOB DATA LOBFILE CONSTANT TEST31 0003 clo CHARACTERSET AL16UTF16 BYTEORDER BIG BYTEORDERMARK CHECK VARCHARC 10 1000 NULLIF NCLOB DATA LOB NONE v4 2 3 159 PLUMSIX Co Ltd __ 23 2 5 SDF LOB CLOB 9999999999 NCLOB BLOB 4 v4 2 3 160 PLUMSIX Co Ltd v4 2 3 161 24 E
266. EXECUTE DECLAREIBEGIN END PL SQL PL SQL PL SQL v4 2 3 90 OPLUMSIX Co Ltd INPUT 83 A PRE_REP_EXEC_PLS PL SQL POST_REP_EXEC_PLS 90 Oracle Virtual Private Database VPD
267. GetTbIN 4 5 6 PL SQL GetPlsP PL SQL PL SQL 4 5 7 PL SQL GetPlsN PL SQL PL SQL v4 2 3 19 PLUMSIX Co Ltd 5 5 1 Oracle Call Interface Oracle 10gR2 11g 12c OCI C
268. LOB VO 1 NUM_ASYNCLOBS 87 PARALLELISM 90 23 1 1 BOM CLOB NLS LANG 3 CHARSETID 75 A ID CHARSETID NCLOB UTF 16BE BLOB 4 LOB LOB 4 N A LOB LOB Empty 0 LOB IS NULL LOBFILE 23 1 2
269. 0 07 mtu c 981 C ProgramData PLUMSIXWntu_4 2 x86 gt Error Oracle Env bat set USERID ORA 12541 TNS C ProgramData PLUMSIX mtu_4 2 x86 gt install Multi threaded Unloader version 4 2 2003 Plumsix Co Ltd All rights reserved ORA 12541 TNS Error xxxx IP rcAttachToServer psOciCommon c 885 rc0ciSvc cOciSvc c 1194 1 18 mtu c 981 C ProgramData PLUMSIXWntu_4 2Yx86
270. 152 3 SELECT FROM INTO lt gt INTO INTO QUERYFIX 30 Windows SQL Windows SQL
271. Jr RemoteFX Graphics RemoteFX Network 1 Total gt 0 1 H 135 31 ERE LogicalDisk Avg Disk 0 00001 10MB OVERLAP BUFFER LENGTH 89 bytes Write Avg Disk 1000 100 Avg Disk bytes Write sec Write Avg Disk Write 10 10 Queue Length Disk Write 0 000001 100MB
272. Query MTU DB 4 1 8 1 v3 06 39 8 3 45B 1 8 7 46 8 8 47 Unload GetMeta Query 9 39 9 A Query Query 8 1 v3 06 39 8 2 40 8 3 45 O O 8 4 45 8 5 45
273. SQL Loader SQL Plus PARALLELISM 90 4 4 SQL GetMeta v4 2 3 16 PLUMSIX Co Ltd 3 GetMeta CREATE DATABASE LINK CREATE SEQUENCE CREATE CLUSTER CREATE INDEX CLUSTER CREATE TABLE ADD CONSTRAINT PRIMARY KEY ADD CONSTRAINT UNIQUE ADD CONSTRAINT FOREIGN KEY REFERENCES ADD CONSTRAINT gt CHECK
274. DEPPENDENT 77 UnLoad ORA 01466 truncate Instant Client ORA 12705 Cannot access NLS data files or invalid environment specified ORA 12705 NLS Oracle Instant Client NLS LANG set LANG japanese japan a16sjis 27 3 v4 2 3 179 PLUMSIX Co Ltd Warning 1 C ProgramData PLUMSIXWntu_4 2 x86 gt unload Multi threaded Unloader version 4 2 12 1 100 0 00054 NOWAIT 0 13
275. OpenOffice org 3 3 2 1 Oracle OraClientiig homei PLUMSIX J mtu v4 1 64 bit GetMeta xil Query x Unload B X C X D TPLUMSIX 1 mtu_4 2 mtu_4 2 OK license dat ProgramData gt jj Adobe gt Application Data b Desktop ba Documents gt jj Emurasoft gt Favorites b McAfee gt Jj Microsoft gt L Microsoft He gt PLUMSIX 0 PLUMSDC v4 2 3
276. TABLESPACE PAR3 SUBPARTITION P3 TABLESPACE 4 PARTITION 4 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE BUFFER POOL DEFAULT SUBPARTITION P4 P1 TABLESPACE SUBPARTITION P4 P2 TABLESPACE PAR2 SUBPARTITION P4 TABLESPACE PAR3 SUBPARTITION P4 P4 TABLESPACE PAR4 GetMeta Tabs 000018 TEST24 drop table TEST24 create table TEST24 0001 ARIA ID number 4 0002 MP ID number 4 0003 ITEM ID number 4 0004 TAGNO char 10 0005 date 0006 VALUE number 12 3 0007 STATUS number 4 constraint TEST24 PK primary key 0001 ARIA ID 0002 MP ID v4 2 3 27 PLUMSIX Co Ltd 0003 ITEM ID not deferrable initially immediate disable validate pctfree 10 pctused 40 initrans 1 maxtrans 255 nocache parallel degree 1 instances 1 tablespace USERS storage initial 128k next 128k minextents 1 maxextents 65536 buffer pool DEFAULT partition by RANGE subpartition by LIST ITEM_ID subpartition template 00
277. a truncate table b REPLACE SQL Loader c REPLACE or TRUNCATE SQL Loader 6 6 CHAR NULL NULL PRESERVE BLANKS NULL NO PRESERVE BLANKS VARCHAR2 VARCHAR2 PRESERVE BLANKS
278. 2014 03 0 UnLoad 2014 03 0 4 Fm ied MTU 2014 03 0 e Ej 2014 03 0 amp 2014 03 0 MTU v4 2 64 bit orasan ei 2014 03 0 B 51757 v 7 Ell Windows Server 2012 R2 2105 A Users v4 2 3 44 OPLUMSIX Co Ltd Administrators 12 Users 32 bit 64 bit MTU_USER_DIR_X86 MTU_USER_DIR_X64 8 3 Administrator PLUMSX mt
279. OUTPUT FILEMETA SQL Plus sql BODY sql PL SQL DBMS_REFRESH_MAKE sql PL SQL DBMS_JOB_SUBMIT sqal MIN BULK SIZE 1 lt MAXLONGSIZE 32 MINIDUMP_TYPE 21 0x0 MiniDumpNormal Include just the information necessary to capture stack traces for all existing threads in a process C
280. Oracle 10g Client Instant Client TNS ADMIN lt uUsername gt lt password gt 0 host port service name password 1 11 MTU 168 B 15 1288 DB Oracle 11g SEC_CAS
281. SAM Sequential Access Method NCHAR NVARCHAR2 UTF 16BE NUMBER 10 COMP 3 DISPLAY SIGN LEADING SEPARATE e 22 154 8 8 CreateFile Windows APD FILE FLAG_NO_BUFFERING O OVERLAP_BUFFER_LENGTH 89 VO v3 063 19 6 100MB Windows 64kB I O
282. SKIPSCR fg UnLoad dat ctl SORTING 18 SORTED INDEXES PK AK
283. dat CSV SQL Loader RECLENGTH 93 v4 2 3 71 PLUMSIX Co Ltd lt gt lt gt lt gt UnLoad Query _conn sqal CONNECT _par0 txt _par1 USERID 1 15 128 192 EMBED_COLU
284. k OT P 10 0 10 3 10 6 10 9 10 12 38 10 15 kB s 1 Len 1 v4 2 3 STREAM_LOCATOR 98 ENCLOSER ENCLOSER2 78 B lt 1 1 1 1 Oracle BULK_SIZE 75 B FEEDBACK 80
285. 32 mtu_xxx msi xxx bit 11 43 35 DelCircular sql FK mkcrd exe mpx exe x64 x86 MTU xla Excel mtu exe 64 x86 FH sglite3 dll SQLite ver 3 sqlite3 exe SQLite ver 3 PsPas cer PsPasCli dll PsPasCom dll
286. PLUMSIX Co Ltd envbatsignlcs datlicense dat input qryvar qryfix 8 39 env bet env bat input qryvar qryfix env bat
287. v4 2 3 136 PLUMSIX Co Ltd 6 TAF MTU Oracle Net Services FO_REAUTH p F O B8 FO_BEGIN 2011 08 04 MTU TAF_DELAY_TIME 98 Information Failing over fo_type SELECT Please stand by n HA DataGuard n n 5
288. 108 PLUMSIX Co Ltd 71 e MTU amma s i ookup a i A r7 P OK ry B U Mtu 8 Excel E 2 Excel Office XP ED O T 7 90 B x 3 Office 2007 HI Microsoft Excel x CM HA BRO 75 MEE 9 Quick Export Oracle SQL Loader 10 4 MTU Quick
289. 2 CHARSETID 0 CLOB LOB NLS LANG 3 Windows 832 873 871 CLOB LOB UTF 8 Oracle 2 UnLoad Oracle 15 13 Unicode v4 2 3 75 PLUMSIX Co Ltd 125 CHARSETID SELECT NLS_CHARSET_ID VALUE AS CHARSETID SUBSTRB VALUE 1 10 AS CHARSET_NAME FROM V NLS VALID VALUES WHER
290. B 4 0 28 d RR 8 0 39 A G output b TableName NumRows Elapse Rows s Bytes kB s DEPT 4 0 01 279 160 11 12 0 01 1070 869 76 SALGRADE 0 01 517 182 18 TEST18 0 01 154 122 9 1 0 02 40 245 10 FK constraints 0 18 constraints 0 00 2 45 0 00 0 00 Bd 0 43 5 0 01 0 02 0 01 5 0 02 0 03 0 02 0 05 0 03 gt a gt gt 5 0 01 0 01 0 02 2 0 01 SQL Loader kbytes kbytes o N gt n5 C YProgramDataYPLUMSIXYmtu 4 2Yx86 a LISTTABLE 84 E LISTEXC
291. Information Failover error gotten Retried time s Sleeping Information Failover ended resuming services Information E f Failover ended resuming services HASH PART TABLE P2 124 973 8 31 14k 19M 2432k 165 HASH PART TABLE P7 124 904 6 25 19k 19M 3232k 165 v4 2 3 137 OPLUMSIX Co Ltd Information Failover aborted Failover will not take place tnsnames ora RAC PLUMSIX LOCAL DESCRIPTION ADDRESS_LIS
292. SW 2A 9 028 EE oi K 22 GetMeta 23 Unicode es v4 2 3 8 PLUMSIX Co Ltd 24 125 uq Enim DU 127 26 vq M 128 27 P W envbat 5845 ttt 130 28 STREAM LOCATOR 6 141 29 STREAM_LOCATOR 141 EaR EI AGD S t LADE TA 145 LIAD IIA 162 JAJIL CE ERR 167 33 SR 169 34 E 7 SJ I S AE 72 REM 186 35 7 H7 245 191 308 A ose JD TUS DU c acento tuia utto pta aatis md uda aud 192 v4 2 3 9 PLUMSIX Co Ltd 1 Multi threaded Unloader MTU
293. puasa ES A k EUU ES 0 BAYPREN hte VERIS GS Secure servermane 2 O TELA Q http servemame l proxy pac FIND E VPN 708 9 1 Soks Q TILAN NOOREL VIPER VPN 7 5250 51 5 EEMETA IO E 0 5 IP 3982 5 LAN LAN Esc E RIP TR C COBRE AQ OK ARA v4 2 3 0 PEAB servername 2 M NI 8080 u PELAGI AB v amp T020F3JE 520 9 31 89 500 servername 3 HIY 0 PLUMSIX Co Ltd _ _ C e E
294. 20 52 Unboad IESU EC MEM C MM MM MC EA 20 5 3 GetMeta T BB conserere E e Red ttd 23 BRE asr OM Roe c M C 31 GENI eA MC V 31 EI NR E E RR a Sa 32 Ka sN Si NO NO 32 bA EU BENE Lec usce ipd A LEE dl 33 6 5 UnLoad Query 4 33 ie mibi parado gramos ode enacted cd 35 6 7 TIMESTAMP WITH LOCAL TIME ZONE 0 HEEL Eee ttti 35 O 8 Get Meta 36 68 Millay 36 UR 37 Vd aid La oU LE ues some aei nem osa iR 37 I MOVA TADI TZI U R MR DEN aa 37 7 3 v3 06 W v4 2 37 7 3 1 v4 2 i LAr SEE 37 S GUB 38 39 8 1 v3 06 39 40 EEO U 45 v4 2 3 1 PLUMSIX Co Ltd 8 4 45 8522 LVE DIT EE EE 45 ooo 46
295. CSV EMP UnLoad 29 1 1 LOAD INFILE EMP VAR 10 INTO TABLE EMP TRUNCATE REENABLE FIELDS TERMINATED BY EMPNO DECIMAL EXTERNAL 5 ENAME CHAR 10 ENCLOSED BY JOB CHAR 9 ENCLOSED BY MGR DECIMAL EXTERNAL 5 HIREDATE DATE 14 YYYYMMDDHH24MISS ENCLOSED BY 77 SAL DECIMAL EXTERNAL 9 COMM DECIMAL EXTERNAL 9 DEPTNO DECIMAL EXTERNAL 3 29 1 2 00000000597369 SMITH CLERK 7902 19801217000000 800 20 00000000667499 ALLEN SALESMAN 7698 19810220000000 1600 300 30 00000000657521 WARD SALESMAN 7698 19810222000000 1250 500 30 v4 2 3 186 PLUMSIX Co Ltd 00000000627566 JONES MANAGER 7839 19810402000000 2975 20 00000000687654 MARTIN SALESMAN 7698 19810928000000 1250 1400 30 00000000627698 BLAKE MANAGER 7839 19810501000000 2850 30 00000000627782 CLARK MANAGER 7839 71981060900000077 2450 10 00000000627788 SCOTT ANALYST 7566 771987041900000077 3000 20 00000000597839 KING PRESIDENT 19811117000000
296. ID H FARF 2 jog FINDSTRCMD Unload Query grep UNIX findstr WindowsNT 2000 XP Windows95 98 Me set FINDSTRCMD find n WINTARGET 99 WINTARGET fndstr n grep n FPNUMFMT NUMBER FLOAT 9 9 99999999999999999999999999999999999999EEEE 9 38 Ver 2 11 999999999999999999999999999999999999999 9 39 NUMBER 10 2 FPNUMFMT
297. SELECT x INTO EXP AS CSV FROM EMP WHERE JOB b job e XXXXXXX ORCL world SCOTT b_job SALESMAN b_job SALESMAN f EWP g h kd 1 m mes gt E Bi c Ytempmtu 306 C Ybor land USER mtu c temp mtu_306 output C Ybor land USER mtu output mtu x88 exe MTU log Q ID Multi threaded Unloader MTU 110 PLUMSIX Co Ltd 2 n Oracle DATE DATE MASK 77 o Oracle TIMESTAMP TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP_MASK 98 TH p Oracle TIMESTAMP WITH TIME ZONE TIMESTAMP TZ MASK 98 q Oracle LONG MAXLONGSIZE 85
298. 141 19 1 em 141 sss s N 143 145 20 3E 00 db 149 QUAE SEDET 22 22 1 Unload Query DAA ORE 154 154 23 LOBB pak 155 23 LOBFIE E 5 155 293 de MM EI UMP LEE 155 23502 rel bm Jb md cct E dud EE ES 155 156 23 1 4 POEM uM T cc M 232 SDR 292 9 MEM IMP HM EU REDEEM MEI IE 157 209222 E Ibn db DM 157 2921322 eris e PR RR MER 158 MEM M LS 158 232 5 Tiu 159 2A TE RE b RUN ABENE 24 2 24 URN udo RERO 242 ERE do qulbus d
299. 3 CHARSETID CHARSETID 17 Oracle ID ID Oracle 873 AL32UTF8 871 UTF8 832 JA16SJIS e 1 ID 1 global name global name xxxx 1 DEDICATED SHARED 7 http msdn microsoft com en us library windows desktop ms683194 28v vs 85 29 aspx
300. DRAN I SUPCR 69 qc E 69 essa ED 69 11 22 ss ciconia EET 69 Sec op SED QD ES OU Y C ed dace docet 70 ISTAT 2 cU NER 70 11 4 11 5 ALTER 6 222 224 AU NIPIARYIDEST RED A v4 2 3 2 OPLUMSIX Co Ltd BIND ce sau nap Sium uuu a pair maa 74 JUPE 74 e 74 CHARSETID eee udine ER MO PD 74 CLENTID iR be e eM bebe ab ett 75 CMNTEVE 75 COMPRES S seb 75 5 tt aaa waaka et RR detto AE A NEN DATAEXT DATE MASK DEPENDENT dtt d o a c DL VAR CUIUS DFILE AET DIRS iesea a a ua 76 eus edP enu u Sa eiit dea RR 76 DISCRETE SERE am edet enin ean AMORC e DR I AMET 76 DST teen teo em E c e e ER e boa Pata uere none ditti 71 eeu OR RS UR E a eee paq eoe bans 71 ENGEOSER ENCLEOSER2 e bemus UR RU P uD ug ART P axe Dd Re da 71
301. FOO FOO connect as sysdba alter system set audit_trail DB scope spfile shutdown immediate startup audit table index alter table by scott connect scott tiger create table 00 cl varchar2 3 alter table 00 add c2 number 10 9 alter table 00 add constraint 00 PK primary key cl create index 00 01 on F00 c2 exit NUMDAYS_AUDIT 1 GetMeta FOO v4 2 3 28 PLUMSIX Co Ltd CREATE TABLE ALTER TABLE CREATE TABLE Tabs 000004 00 drop table 00 create table F00 0001 C1 varchar2 3 0002 02 number 10 9 constraint 00 primary key 0001 C1 not deferrable initially immediate disable
302. SELECT ANY TABLE Oracle Query 8 4 45 Oracle Net oracle world SYSTEM set USERID SYSTEM MANAGER oracle wor ld identified externally create user set USERID Oracle 10g 7 host port service_name TNS ADMIN set USERID SYSTEM MANAGERQ l oca host 1521 ora
303. mtu c 1004 C ProgramData PLUMSIXWntu_4 2 x86 gt Query ORA 01008 C XProgramDataYPLUMSIXXmtu 4 2 86 gt query Multi threaded Unloader version 4 2 12 1 100 1 QUERYFIX qryfix sql 2 QUERYVAR qryvar sql input bind dat b_sal 1 300 b_hiredate 1980 01 01 4 output TableName NumRows Elapse Rows s Bytes kB s Len DEPT 0 0 00 ORA 01008 rcStmtExecute cOciStmt c 466 rcExecDefineAndFetch c0OciStmt 980 2 Selec
304. x64 12 0 21005 MICROSOFT VISUAL C REDISTRIBUTABLE FOR VISUAL STUDIO 2013 DASS TES LUDEN oni 47 Microsoft Visual C 2013 Redistributable x64 12 0 21005 4 E DM gt JU55h 2 7 N n 5 LET a 5 5 AE 222 7 c ans 35 Microsoft Visual C 2013 Redistributable x64 12 0 21005 Microsoft Corporation 0 U ler v4 2 0 bit RER Plumsix Co Ltd E Oracle VM VirtualBox Guest 4 3 6 Oracle Corporation update for Japanese Microsoft IME Postal Code Dictionary Microsoft Corporation 6 Update for Japanese Microsoft
305. 5 7 tablespace PAR2 subpartition p3 values NULL tablespace PAR3 subpartition p4 values DEFAULT tablespace PAR4 partition pl values less than to_date 20050401 yyyymmdd partition p2 values less than to_date 200505017 yyyymmdd partition p3 values less than to_date 200506017 yyyymmdd partition p4 values less than MAXVALUE create index TEST24_IEO1 on TEST24 item id local DBMS METADATA GET DDL TEMPLATE SUBPARTITION P1_P1 Oracle SQL SQL set pagesize 2000 long 10000 linesize 180 SQL select dbms metadata get ddl TABLE TEST24 SCOTT as DDL from dual DDL
306. 7 7 D x z 7 21 ALL O Z HIE E G H EMPNO ENAME 7499 ALLEN 7521 WARD JOB SALESMAN SALESMAN SALESMAN SALESMAN 7844 TURNER 1 2 3 4 7654 MARTIN 5 6 1 M Sheet Sheet3 MGR 7698 1981 2 20 000 1600 7698 1981 2 22 000 1250 7698 1981 9 28 000 1250 7698 SAL DEPTNO 300 30 500 1400 1981 9 8 000 1500 0 lt R gt gt D O ud G 31 gt Z v4 2 3 111 PLUMSIX Co Ltd Ej 12 MTU 2 t A 1 FID es SINT NUES f olllutf8 Thread FIF0 cThread cOciSes FIFO c ciSes 0 Oracle Database llg Enterprise Edition Release 11 1 0 6 0 Production With the Partitioning OLAP Data Mining and Real Application Testing options GOCI 1002000400 TH 11010
307. CREATE TABLE SCOTT TEST24 ARIA ID NUMBER 4 0 MP ID NUMBER 4 0 ITEM ID NUMBER 4 0 TAGNO CHAR 10 DT DATE VALUE NUMBER 12 3 STATUS NUMBER 4 0 CONSTRAINT TEST24 PRIMARY KEY ARIA ID MP ID ITEM 10 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 v4 2 3 24 PLUMSIX Co Ltd PCTINCREASE O FREELISTS 1 FREELIST GROUPS 1 BUFFER POOL DEFAULT TABLESPACE USERS ENABLE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 65536 BUFFER POOL DEFAULT TABLESPACE USERS PARTITION BY RANGE DT SUBPARTITION BY LIST ITEM_ID SUBPARTITION TEMPLATE SUBPARTITION P1 values 1 8 9 TABLESPACE SUBPARTITION P2 values 2 4 5 T TABLESPACE 2 SUBPARTITION P3 values NULL TABLESPACE PAR3 SUBPARTITION P4 values DEFAULT TABLESPACE PARA PARTITION P1 VALUES LESS THAN TO DATE 2005 04 01 00 00 00 SYYYY MM DD HH24 MI SS NLS CALENDAR GREGORIAN PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 65536 BUFFER POOL DEFAULT TABLESPACE USERS SUBPARTITION P1 P1 VALUES C1 8 9 TABLESPACE SUBPARTITION P1 P
308. Code 0x3 Msg C XProgramDataYPLUMS IXXmtu 4 2 x86 gt getmeta Multi threaded Unloader version 4 2 12 1 2 SCOTT Error Win32API Code 0x3 Msg rcCchkWin32Api O rcChkWin32Api c 30 Error outpugYmeta sql rcFileO cFile 408 rcGetMeta psGetMeta rcGetMeta c 633 0 25 v4 2 3 176 OPLUMSIX Co Ltd 1004 C ProgramData PLUMSIXWntu_4 2 x86 gt 3 Env bat OUTPUT 89 Error Win32API Code 0x5 Mss C ProgramData PLUMSIX mtu_4 2 x86 gt getmeta Multi threaded Unloader version 4 2 m 1
309. Export Quick Export on Oracle R SQL Loader Delete MTU Menu bar v4 2 3 109 OPLUMSIX Co Ltd a 25 25 b DB SRC_USER 97 e SELECT lt QUERYVAR 92 f key value FILEBIND 80 g
310. IME Standard Dictionary Microsoft Corporation Update for Japanese Microsoft IME Standard Extended Dictionary Microsoft Corporation k 87 7 MB 2014 01 27 2014 01 27 2014 01 22 2014 01 27 2014 01 27 2014 01 27 20 5 MB 7 76 MB 7 58 MB 40 3 MB 11 5 MB 12 0 21005 1 420 4 3 6 0 15 0 1157 15 0 1080 15 0 1080 Microsoft Visual C 2013 Redistributable xNN 12 0 NN 86 64 v4 2 3 190 PLUMSIX Co Ltd 31 11 43 BD
311. MTU Oracle Oracle Oracle Database 10g 24 1 Oracle Database 10g for Microsft Windows x64 ORACLE HOME CXOracleYproductX10 2 0Xdb 1 Oracle OraDb10g home1 2 Oracle Database Client 10g for Microsoft Windows 32 bit ORACLE_HOME C Oracle product 10 2 0 client_1 Oracle OraClient10g home1 PATH 2 Oracle PATH C Oracle product 10 2 0 client_1 bin PATH C Oracle product 10 2 0 db_1 bin PATH XIZ MTU unload bat getmeta bat echo off rem WOW64 Microsoft 896456 URL http support microsoft
312. NCLOB DATA LOB FILLER CHAR 28 ENCLOSED BY NCLOB DATA LOBFILE NCLOB DATA LOB CHARACTERSET AL16UTF16 BYTEORDER BIG BYTEORDERMARK NOCHECK TERMINATED BY EOF NULLIF NCLOB DATA LOB NONE 23 1 5 LOBFILE LOB Oracle Database 10g 10g v4 2 3 157 PLUMSIX Co Ltd CLOB 4 8 NCLOB BLOB 23 2 SDF SDF v4 18 MERGE LOBS INTO SDF 85 SDF LOBFILE LOB Oracle Database Oracle Database 11g LOB
313. Visual Studio Windows Windows Server Windows XP Windows Vista Visual C Microsoft Corporation Intel Pentium Itanium Intel Corporation v4 2 3 195 PLUMSIX Co Ltd
314. bit Oracle Database for Microsoft Windows 32 bit Oracle Database Client for Microsoft Windows 32 bit WOW64 MTU 14 x64 Windows 126 8 6 2 bit 1 64 bit 32 bit 1 64 bti Windows Intel Itanium Windows
315. com kb 896456 ja 2 ORACLE HOME Oracle v4 2 3 126 OPLUMSIX Co Ltd rem Copyright c 2007 Plumsix Co Ltd All rights reserved rem call dpOYenv WEXECUTABLE Wuserid UnLoad IF ERRORLEVEL 1 pause h echo off em rem Copyright c 2007 Plumsix Co Ltd All rights reserved em call dpOYenv EXECUTABLE userid UnLoad IF ERRORLEVEL 1 pause mtu exe OCLDLL PATH C oracle product 10 2 0 db_1 bin C oracle product 10 2 0 client_1 bin MTU x86 OCLDLL TNS ADMIN Oracle Database sqlnet ora tnsnames ora Oracle Client Oracle Client Oracle Client ORACLE_HOME 23 Oracle for Windows ORACLE_HOME bin oracle key ORACLE HO
316. dat TBL_04 dat 0 TBL TBL sql 1 PARALLELISMI 90 16 2 01 LOAD INFILE 0 1
317. elapsed findstr n log gt gt _errmtxt 10 10 findstr n 10 101 competed 067s elapsed findetr n log gt gt _errmtxt n i MPX Reload bat c d d d EXEC_MPX pa MULTIPLE pc PRIORITY_CLASS sw 6 SW_M i findstr d 00 SW_CSI SW_CS0 c bat j NNN elapsed
318. et 92 REGOVERABLEE RS usa Re Dod ee e e nte k una 92 RERUNP ON s qa 92 REVERSEBYTEORDER tenete ea Ahi 92 ROWID SPLELT MIN SIZE ES ee ei i e Het E te eta tbt epe 93 v4 2 3 4 PLUMSIX Co Ltd 93 ROWSEPARATOR ee 94 94 SHOWOLTDTM a 94 SHOWSLPATm amupa UM UR PI EM UNI m Ud 94 SHOWSTNM To ii 94 ette e ot 94 SKIPSCR SORTING 95 95 SR 96 STDOUTLi eec III 96 STREAM LOCATOR s eer Meer cnp MEL Ap UII 97 TAF DELAY TME ttt ttt ttt t ttt tts 97 ette etur etu t a i LUN uti aM LM eie UTE 97 TIMESTAMP EA 97 TIMESTAMP TZ MASK narrar n a E EEEE E E ttt ttt EE EEEE aaae 97 THBEADIBRIORIDY 97 USERID 98 SA 98 WINTARGE MERERI 98 2 99 12 1 99 2 101 EIU 12 44 2492
319. gt report unrecoverable File Type of Backup Required Name full or incremental G YORACLEYORADATAYO10G2YDATAFILEYO1_MF_USERS 427SQ7WB _ Repot unrecoverable 9 nologging backup RMAN gt backup incremental level 0 datafile 9 backup 08 12 27 ORA_DISK_1 0ORA_DISK_1 sid 141 devtype DISK ORA DISK 2 ORA_DISK_2 sid 158 devtype DISK ORA_DISK_3 ORA_DISK_3 sid 138 devtype DISK ORA_DISK_4 ORA_DISK_4 sid 136 devtype DISK 0ORA_DISK_1 0 0ORA D
320. i Eri 4 S Ctrl T Ug Y mi 723 pU 7 5 214 p Ug 10 03 43 10 08 3310 11 43 0 939 12 405 0 000 54 225 33 20 Avg Disk Bytes Write Total LogicalDisk XXWIN20 Avg Disk sec Write Total LogicalDisk XXWIN20 Avg Disk Write Queue LogicalDisk XXWIN20 Disk Write _ Total icalDisk WIN20 24 2 logman Performance Logs amp Alerts lt Windows
321. testes edet deba teda leder Sp tute scan 187 29 4 GetMeta 188 30 Visual Studio 2013 Visual Vy 47 22 0038 Jtt ttti 189 JUS dL A OD SE E se E E D E 190 191 gab m 193 ISI A 194 EAE Li AOE LA 2 UnLoad Oracle EV ADAN a n oT E A ODA T E 17 HW dod 18 EMA Dap 23 I asam aha 31 E 7 Lk 8 MTU Oracle 9 AOS a V 39 10 TAO a E E 40 Pawiu 43 12 Users A a e 45 13 PL SQL e DREAM MEUS AMI 51 14 ABC 70 15 ABC MO Mp c uu LIII MM 277 100 K 17 Oracle DL 100 R 18 Unload B SR SR eod acad Mose beds ca Nu aga tu CU ELO 103 K 19 MTU MPX 113
322. validate pctfree 10 pctused 40 initrans 1 maxtrans 255 nocache parallel degree 1 instances 1 tablespace SYSTEM storage initial 64k minextents 1 maxextents unlimited freelists 1 freelist groups 1 buffer pool DEFAULT create index 00 IEO1 on 00 0002 C2 pctfree 10 initrans 2 maxtrans 255 parallel degree 1 instances 1 tablespace SYSTEM storage initial 64k minextents 1 maxextents unlimited freelists 1 freelist groups 1 buffer pool DEFAULT create UNIQUE index 00 PK 0001 01 pctfree 10 initrans 2 maxtrans 255 parallel degree 1 instances 1 tablespace SYSTEM storage initial 64k minextents 1 maxextents unlimited freelists 1 freelist groups 1 buffer pool DEFAULT alter table F00 enable validate constraint PK audit trails of the target actions 2008 09 06 22 35 19 14859 1 CREATE TABLE 00 hogeYfoo bar SCOTT 0 CREATE TABLE 2008 09 06 22 39 03 14859 ALTER TABLE 00 hogeYfoo bar SCOTT 0 2008 09 06 22 39 03 14859 CREATE INDEX 00 PK hogeYfoo bar SCOTT 0 2008 09 06 22 39 03 14859 ALTER TABLE 00 hogeYfoo bar SCOTT 0 2008 09 06 22 40 51 14859 CREATE INDEX 00 IEO1 hogeYfoo bar SCOTT 0
323. 0 xxx dat xxx SQL Loader 555 LONG LONG RAW readsize 1048576 _par0 txt _par1 txt ORA 06564 ALIAS1 GETEXTTBL 83 system ALASI SCOTT SCOTT connect system manager create or replace directory ALIAS1 as C YborlandYUSERYmtuXoutput SQL CREATE ANY DIRECTORY grant read write on directory ALIAS1 to scott connect scott ti
324. 00600 SYSTEM 0111UTF8 j LOCAL olllutf8 DEDICATED 1 1D 230406 Ed 2010 08 12 10 41 14 SCOTT cVectar FIF0 cVector Col ttrPool cVector RowDataPonl clector RouDataPool d ERE xd cl ector BufPool HE cVector BufPool 0 m EU QUERTVARO S ELECT FROM EMP WHERE JOB b_job b jobz SALESMAN b Joh SALESMAN cOciSes bi E amp d 0 C borland USER mtu output TableName NumRows Elapse Rows s Bytes kB s Len EXP AS CS 13 EXP AS CSV 4 0 15 27 318 2 18 5 25 re 0 95 1 0 8 kbyte ien 1 8 C Ybor landYUSERYmtuYoutput WTU log 12 4 2 QikExp bat 1 43 QikExp bat 2
325. 01 subpartition P1 values C 1 8 9 tablespace 0002 subpartition P2 values 2 4 5 T tablespace PAR2 0003 subpartition values null tablespace PAR3 0004 subpartition P4 values default tablespace 0001 partition P1 values less than to_date 2005 04 01 YYYY MM DD 0002 partition P2 values less than to date 2005 05 01 YYYY MM DD 0003 partition P3 values less than to date 2005 06 01 YYYY MM DD 0004 partition P4 values less than maxvalue create index TEST24 IEO1 on TEST24 x 0003 ITEM pctfree 10 initrans 2 maxtrans 255 parallel degree 1 instances 1 storage buffer pool DEFAULT local 11g NUMDAYS_AUDIT 88 E
326. 2 VALUES 2 4 5 T TABLESPACE PAR2 SUBPARTITION P1 P3 VALUES NULL TABLESPACE PAR3 SUBPARTITION P1 P4 VALUES DEFAULT TABLESPACE 4 PARTITION P2 VALUES LESS THAN TO DATE 2005 05 01 00 00 00 SYYYY MM DD HH24 MI SS NLS CALENDAR GREGORIAN PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 65536 BUFFER POOL DEFAULT TABLESPACE USERS SUBPARTITION P2 P1 VALUES C1 8 9 TABLESPACE SUBPARTITION 2 P27 VALUES 2 4 5 T TABLESPACE PAR2 SUBPARTITION P2 VALUES NULL TABLESPACE PAR3 SUBPARTITION P2 P4 VALUES DEFAULT TABLESPACE 4 PARTITION P3 VALUES LESS THAN TO DATE 2005 06 01 00 00 00 SYYYY MM DD H24 MI SS NLS CALENDAR GREGORTAN PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 65536 BUFFER POOL DEFAULT v4 2 3 25 PLUMSIX Co Ltd TABLESPACE USERS SUBPARTITION P3 P1 VALUES C1 8 9 TABLESPACE SUBPARTITION P27 VALUES 2 4 5 T TABLESPACE PAR2 SUBPARTITION P3 P3 VALUES NULL TABLESPACE PAR3 SUBPARTITION P3 P4 VALUES DEFAULT TABLESPACE 4 PARTITION P4 VALUES LESS THAN MAXVALUE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE INITIAL 131072
327. 2420 SE z suyan 165 v4 2 3 6 PLUMSIX Co Ltd EU n mM 166 i000 PE DN 167 VICE TS 169 TAI E MM IE 170 27 1 EE 170 Error OCLDLL Do 170 edo OINEAN EE A 170 ORA 12154 TNS cucu 171 ORA 12541 TNS 171 ORA ONO0S4 ORACGLE hot avala Dle eerte ei ete i 171 ORA 12560 TNS K KK 172 ORA 01017 ett 172 ORA 00955 a EE 173 ORA 01031 TE IRA ABL C UNIES o n tee ba ee dal ed baci o tuuc cl ea RC e 173 ORA 01950 xxxxxx ORA 01536
328. 3999 12 31 CPU PU AB 50 0288 2 PLUMSIX Co Ltd ALLUSERSPROF ILE PLUMS IX mtu_4 2 1 icense dat CPU Multi threaded Unloader version 4 2 2003 Plumsix Co Ltd All rights reserved Windows 7 Professional Service Pack 1 build 7601 64 bit native Number of NUMA nodes 1 Number of physical processor packages 1 Number of processor cores 2 Number of logical processors 2 Number of processor L1 L2 L3 caches 4 1 0 Information 2012 05 03 9999 12 31 CPU 2 CPU 4 9 1 9 Windows 26 2400 2075 WESC FRERE LETRO FMD
329. 4 342 T 117 0 31 0 47 3 06 0 03 0 43 0 05 0 00 0 03 0 17 0 18 0 09 0 15 0 04 0 21 1 18 0 12 0 43 0 43 0 03 0 24 0 23 0 08 0 00 0 00 0 38 0 08 0 07 0 13 0 12 0 04 PLUMSIX Co Ltd L0B kbytes kbytes IE T oss Ts C XProgramDataYPLUMSTXXmtu 4 2Yx86 a OUTPUT 89 FILEMETA 81 GetMeta 11 70 22 GetMeta CMNTLVL 76 COMPRESS 76 DEPENDENT 77 METADIV 85 NMENCLS 87 NUMDAYS AUDIT 88 PRINTCOLID 91 b
330. 4 2Yx86 a OUTPUT FILEPLSP 82 b APLDDT02 v4 2 3 121 PLUMSIX Co Ltd c 500 FEEDBACK 0 c d e OUTPUT FILETBLP 12 8 5 GetTbIN 1 43 Env bat Envjbat
331. 5000 10 00000000657844 TURNER SALESMAN 7698 19810908000000 1500 0 30 00000000607876 ADAMS CLERK 7788 19870523000000 1100 20 00000000597900 JAMES CLERK 7698 19811203000000 950 30 00000000617902 FORD ANALYST 7566 19811203000000 3000 20 00000000617934 MILLER CLERK 7782 19820123000000 1300 10 29 2 UnLoad 34 EMP UnLoad LISTFIXED 84 El FILEFIXED 81 CSV 6 6 35 8 34 LISTFIXED 84 Ei FILEFIXED 81 B lt gt 29 2 1 LOAD INFILE EMP FIX 66 INTO TABLE EMP TRUNCATE REENABLE FIELDS EMPNO POSITION 1 5 DECIMAL EXTERNAL ENAME POSITI
332. ABLE 000002 VAR 10 INTO TABLE NON PART LARGE TABLE MTU xxxx Error XxXxXxXX DFILE ALT DIRS EMBED COLUMN NAME 78 EMBED_COLUMN_NAME DFILE_ALT_DIRS v4 2 3 141 PLUMSIX Co Ltd 19 STREAM LOCATOR STREAM LOCATOR STDOUT 97 STDOUT 0 STREAM_LOCATOR ipc_pipe named pipe 28 STREAM LOCATOR
333. ACE SQL select from session privs where privilege UNLIMITED TABLESPACE 8 7 Env bat SRC_USER 97 Oracle 11g SCOTT v4 2 3 46 PLUMSIX Co Ltd 8 8 Envjbat USERID USERID mtu exe 25 168 Query
334. D Executing v4 2 3 88 PLUMSIX Co Ltd OPTIMIZER_HINTS lt gt UnLoad PARALLEL OPTIMIZER HINTS PARALLEL 1 4 4 OPTIMIZER_MODE SQL alter session set optimizer mode Oracl
335. E NUMBER SCN 0 lt FEEDBACK lt 64 FBQTIME FBQSCN 80 UNDO FBQTIME yyyymmddhh24miss DBMS_FLASHBACK ENABLE_AT TIME UNDO FEEDBACK 0 lt S FEEDBACK lt 32 0 1 FILELOG 81
336. E PARAMETER CHARACTERSET 64 v active_session_history CLIENT ID v session CLIENT IDENTIFIER SQL trace CLIENT ID Oracle Database 21 1 End to End Application Tracing CLIENT ID CMNTLVL 0 SQL 1 SQL 2 SQL COMPRESS 5 COMPLESS export
337. EAM_LOCATOR 142 8 v4 2 3 12 PLUMSIX Co Ltd 6 lt 2 1 1 2 e 18 139 8 7 Oracle
338. ED BY CX JOBY dummy a MGR DECIMAL EXTERNAL 5 v4 2 3 184 PLUMSIX Co Ltd HIREDATE SAL COMM DEPTNO 16 YYYYMMDDHH24MISS ENCLOSED BY DECIMAL EXTERNAL 9 DECIMAL EXTERNAL 9 DECIMAL EXTERNAL 3 a ENCLOSED BY 2 SQL JOB IS NULL dummy 28 3 EMP COMM LOAD INFILE EMP VAR 10 INTO TABLE EMP EMPNO ENAME JOB MGR HIREDATE SAL COMM FILLER DEPTNO TRUNCATE REENABLE FIELDS TERMINATED BY DECIMAL EXTERNAL 5 CHAR 10 ENCLOSED BY CHAR 9 ENCLOSED DECIMAL EXTERNAL 5 DATE 16 YYYYMMDDHH24MISS ENCLOSED BY DECIMAL EXTERNAL 9 DECIMAL EXTERNAL 9 a DECIMAL EXTERNAL 3 ay FILLER
339. EDBACK 0 b OUTPUT FILEFKRB 12 8 4 GetTbIP 1 43 Enba Envbat 11 70 2 Envbat GetTbIP bat 3 C ProgramData PLUMSIXWmtu_4 2 x86 gt GetTblp Multi threaded Unloader version 4 2 T12 1 100 output tblp txt Z 4 0 04 R B 4 1 28 A 28 7 5 42 kbytes 0 11 2 28 kbytes 0 05 aee r CELH G YProgramDataYPLUMSIXYmtu
340. E_SENSITIVE_LOGON TRUE 2 16 101 U BYvsTEM CP ook 7 RAKFISK tttutB 7 N C SYSDBAA amp C SYSOPERCO 11 MTU v4 2 3 168 OPLUMSIX Co Ltd Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved Windows 7 Professional Service Pack 1 build 7601 64 bit native Number of NUMA nodes 1 Number of physical processor packages 1 Number of processor cores 2 Number of logical processors 2 Number of processor
341. Files x86 PLUMSIX mtu_4 2 x86 64 MTU_EXEC_DIR_X64 ProgramFiles PLUMSIX mtu_4 2 x64 32 MTU USER DIR X86 ALLUSERSPROFILE PLUMSIX mtu_4 2 x86 64 MTU USER DIR X64 ALLUSERSPROFILE PLUMSIX mtu_4 2 x64 31 191 B Windows Vista 7 Server2008 gt PLUMSIX 32 bit 64 bit v4 2 3 43 PLUMSIX Co Ltd Administrator GetMeta ull GetMeta Query uid UnLoad Query 7L7 v V8 Unload J J
342. ISK 1 fno 00009 C ORACLE ORADATA 010G2 DATAFILE O1_MF_USERS_427SQ7WB_ DBF 0ORA_DISK_1 1 08 12 27 0ORA_DISK_1 1 08 12 27 C XORACLEXFLASH RECOVERY AREAXO10G2YBACKUPSETY2008 12 27X01 MF NNNDO TAG20081227T17 2237 40CSG GDG BKP TAG20081227T172237 NONE 0ORA DISK 1 00 00 55 backup 08 12 27 Control File and SPFILE Autobackup 08 12 27 v4 2 3 134 PLUMSIX Co Ltd C 0RACLE FLASH_RECOVERY_AREA O10G2 AUTOBACKUP 2008_12_ 27Y01_MF S 674587413 400SJ6P 7 BKP NONE Control File and SPFILE Autobackup 08 12 27 report recoverable RMAN gt report unrecoverable
343. L1 L2 L3 caches 4 1 0 Error MTU userid func userid world IPC orcl world OS func install unload query getmeta SQL consdisable consenable getfkrb gettblp gettbln getplsp PL SQL getplsn PL SQL mtu c 392 v4 2 3 169 PLUMSIX Co Ltd 26
344. LELISM 90 2 _stdout log _stderr log MTU Information B v4 2 3 145 OPLUMSIX Co Ltd Information E B E MTU EOF End of File MTU
345. LESIZE 82 STREAM LOCATOR 0 19 STREAM_LOCATOR 142 TAF_DELAY_TIME 0 lt DELAY TIME 300 ELEF 60 16 TIMESTAMP_MASK TIMESTAMP TIMESTAMP WITH LOCAL TIME ZONE 9i TIMESTAMP WITH TIME ZONE 9i
346. L_AVG kbytes kbytes oe S fs 224 128 124 151 231 113 3 4 2 3 3 6 6 6 1 1 199 0 8 2 2 C XProgramDataYPLUMSTXXmtu 4 2Yx86 a QUERYVAR 92 B QUERYFIX 91 B CSV QUERYFILENAME 93 EXTNAMESQL 80 Query 30 CSV
347. Ltd 12 env bat 11 70 12 1 C ProgramData PLUMSIX mtu_4 2Xx862Xxxxxxx Multi threaded Unloader version 4 2 c 2003 Plumsix Co Ltd All rights reserved Windows 7 Professional Service Pack 1 build 7601 64 bit native Number of NUMA nodes 1 Number of physical processor packages 1 Number of processor cores 2 Number of logical processors 2 Number of processor L1 L2 L3 caches 4 1 0 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ID xxx xxxxxXxxXX SYSTEM
348. ME v4 2 3 127 PLUMSIX Co Ltd 15 MTU 10g Release 1 OS Oracle Oracle Database MTU 25 ENV BAT outputY conn sql SQL Plus output parO txt outputY par1 txt SQL Loader Oracle
349. MN_NAME f 1 3 Windows gt 6 1 0x09 TAB 0x2c 0x7c 2 0x22 2 0x27 0x28 0x29 3 2 3 3
350. NEXT 131072 MINEXTENTS 1 MAXEXTENTS 65536 BUFFER POOL DEFAULT TABLESPACE USERS SUBPARTITION P4 P1 VALUES 1 8 9 TABLESPACE SUBPARTITION P4 2 VALUES 2 4 5 T TABLESPACE PAR2 SUBPARTITION P4 VALUES NULL TABLESPACE PAR3 SUBPARTITION P4 P4 VALUES DEFAULT TABLESPACE PAR4 SQL select dbms metadata get ddl INDEX TEST24 IEO1 SCOTT as DDL from dual DDL CREATE INDEX SCOTT TEST24 IEO1 ON SCOTT TEST24 ITEM_ID PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE BUFFER POOL DEFAULT LOCAL PARTITION P1 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE BUFFER POOL DEFAULT SUBPARTITION P1 P1 TABLESPACE SUBPARTITION P1 P2 TABLESPACE PAR2 SUBPARTITION P1 TABLESPACE PAR3 SUBPARTITION P1 TABLESPACE 4 PARTITION P2 PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE BUFFER POOL DEFAULT SUBPARTITION P2 P1 v4 2 3 26 PLUMSIX Co Ltd TABLESPACE SUBPARTITION P2 P2 TABLESPACE PAR2 SUBPARTITION P2 TABLESPACE PAR3 SUBPARTITION P2 P4 TABLESPACE 4 PARTITION PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE BUFFER POOL DEFAULT SUBPARTITION P1 TABLESPACE SUBPARTITION P3 P2 TABLESPACE PAR2 SUBPARTITION P3
351. ON 6 15 CHAR JOB POSITION 16 24 CHAR MGR POSITION 25 29 DECIMAL EXTERNAL HIREDATE POSITION 30 43 DATE YYYYMMDDHH24MISS NULLIF HIREDATE BLANKS SAL POSITION 44 52 DECIMAL EXTERNAL COMM POSITION 53 61 DECIMAL EXTERNAL DEPTNO POSITION 62 64 DECIMAL EXTERNAL 29 2 2 v4 2 3 187 PLUMSIX Co Ltd 13695 CLERK 190219801217000000 800 20 1499ALLEN SALESMAN 769819810220000000 1600 300 30 7521WARD SALESMAN 769819810222000000 1250 500 30 7566JONES MANAGER 783919810402000000 2975 20 1654MART IN SALESMAN 769819810928000000 1250 1400 30 7698BLAKE MANAGER 783919810501000000 2850 30 7782CLARK MANAGER 783919810609000000 2450 10 7788SCOTT ANALYST 756619870419000000 3000 20 7839KING PRESIDENT 19811117000000 5000 10 7844TURNER SALESMAN 769819810908000000 1500 0 30 7876ADAMS CLERK 778819870523000000 1100 20 7900JAMES CLERK 769819811203000000 950 30 1902F0RD ANALYST 756619811203000000 3000 20 7934MILLER CLERK 778219820123000000 1300 10 29 3 UnLoad GETEXTTBL 83 a4 read write
352. PT 84 9 FILETABLE 82 E FILEEXCPT 81 B NUM_ROWS 88 b OUTPUT 89 c v4 2 3 103 PLUMSIX Co Ltd 18 UnLoad TableName PARTITIONING 89 NumRows Elapse Rows s 1 Bytes
353. RTS 16 MAX PARALLELISM 0 MAX_PARALLELISM 4 488 CSV DISCRETE 77 0 CSV v4 2 3 94 PLUMSIX Co Ltd ASCI 0x 2 4100 16 0 0x00
354. Reload bat EXEC_LOAD EXEC_PLUS env bat salldr sqlplus f MPX 0 MPX findstr Windows 0 Oracle MPX g MPX Reload bat d EXEC_MPX pa MULTIPLE pc PRIORITY_CLASS sw 6 SW_M i findstr d OUTPUT SW_CSI SW_CS0 c make bat Reload bat OUTPUT env bat OUTPUT 89 h MPX
355. S 0 287G A 1 372G B 2 98G C Unload Query Information from 12G C ProgramData PLUMSIX mtu_4 2 x64 output to 287G A from to LOAD v4 2 3 140 PLUMSIX Co Ltd LOAD INFILE NON PART LARGE TABLE VAR 10 INTO TABLE NON PART LARGE TABLE LOAD INFILE NON PART LARGE TABLE 000001 VAR 10 INFILE AXNON PART LARGE T
356. ST 74 B DBA SRC_USER 97 A ALTER DEST 74 A ISTTABLE 84 A LISTEXCPT 84 FILETABLE 82 El FILEEXCPT 81 LISTTABLE FILETABLE
357. ST18 P1 2008 08 01 0 TEST18 P1 dat 2008 08 01 592 TEST18 P2 ctl 2008 08 01 x 122 TEST18_P2 dat 2008 08 01 i 592 TEST18_P3 ctl 2008 08 01 0 TEST18 P3 dat 2008 08 01 592 TEST18 ctl 2008 08 01 0 TEST18 P4 dat 2008 08 01 312 TEST1_DEPS sql 2008 08 01 0 TEST1_R0000000001_C0006 clo 2008 08 01 2 229 sql 2008 08 01 j 1 459 disable deps sql 2008 08 01 8 729 _make bat 2008 08 01 65 parO txt 2008 08 01 102 _parl txt 2008 08 01 31 wait here bat 28 11 882 2 25 260 097 536 C ProgramData PLUMSIXWntu_4 2Yx86 ctl SQL Loader b dat DATAEXT 77 CHARSETID 75 ID
358. T ADDRESS PROTOCOL TCP HOST xxx xx xx 173 PORT ADDRESS PROTOCOL TCP HOST xxx xx xx 174 PORT LOAD_BALANCE yes CONNECT_DATA SERVICE NAME RAC plums i X 1521 1521 FAILOVER_MODE MTU TAF TYPE SELECT METHOD BASIC RRECONNECT RETRIES DELAY MTU Oracle Oracle Net Service v4 2 3 138 OPLUMSIX Co Ltd 18 MINIMUM FREE SIZE 86 Ei 1
359. TIMESTAMP TZ MASK YYYYMMDDHH24MISSXFF YYYYMMDDHH24MISSXFFTZ HTZM BELOW_NORMAL SCOTT TIGER true true THREAD_PRIORITY USERID USUALPATH WINTARGET 11 5 15 ABC IIR DST INFO DBA conn sql alter session set current schema ALTER DEST MTU DB AUXILIARY_DEST
360. TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND VARRAY Nested Table REF UROWID SQL Loader 29 186 SQL Loader TRUNCATE REPLACE SQL Loader 926 executing delete truncate due to REPLACE TRUNCATE keyword OC ORA 02266
361. Y URL http msdn microsoft com ja jp library windows desktop ms680519 v vs 85 aspx MINIMUM FREE SIZE 0 1 MINIMUM FREE SIZE 64 k M G T P 18 139 UnLoad 16 C 16 16 15
362. YS SYSTEM 1 1 c 1 2 PUBLIC c 2 2 1 9 2 2 PUBLIC 9 select table b select c select any table select any sequence comment any table execute any procedure create any trigger b select execute v4 2 3 30 PLUMSIX Co Ltd 6 6 1 6 OS Windows Vista Service Pack 2 Windows 7 Service Pack 1 Windows 8 Windows 8 1 Windows Server 2008 Service Pack 2 Windows Server 2008 R2 SP1 Windows Server 2012 Windows Server 2012 R2 CPU 1 6GHz Inte
363. aints 5 0 00 Executing 0 67 ORA 24345 NULL cOciStmt c 748 Warning LONG LONG RAW MAXLONGSIZE 1 000 TABLE NAME COLUMN NAME ROW COUNT SIZE IDL UB1 PIECE 2 4 870 b IDL UB1 PIECE 4 12 288 IDL UB1 PIECE 6 1 132 IDL UB1 PIECE 8 2 982 IDL UB1 PIECE 11 3 540 v4 2 3 181 PLUMSIX Co Ltd IDL_UB1 PIECE 13 12 288 IDL_UB1 LONG LONG RAW b 16 OCIInd 65 535 4
364. apldd sql MTU inputXexcpt dat input fixed dat input PostRepPls sql PL SQL input PreRepPls sal PL SQL inputXtable dat CSV qryfix dept sql 1 qryfix UNION_EMP_A sql 1 qryfix UNION_EMP_B sql 2 qryvarXemp sql 2 CSV qryvarXsal avg sql 3 CSV v4 2 3 193 PLUMSIX Co Ltd 33 9 6
365. apsed sqlplus nolog disable deps Synchronized 3 10 completed 3 79s elapsed sqlldr parfile parl txt rows 10000 control DEPT 2 10 completed 3 80s elapsed sqlldr parfile parl txt rows 10000 control EMP Waiting 4 10 completed 4 67s elapsed sqlldr parfile _par1 txt rows 10000 control SALGRADE v4 2 3 113 PLUMSIX Co Ltd Synchronized 5 10 completed 1 20s elapsed sqlplus nolog QEMP DEPS Waiting 6 10 completed 1 24s elapsed sqlplus nolog DEPT_DEPS 7 10 completed 2 02s elapsed sqlplus nolog SALGRADE_DEPS Synchronized 8 10 failed with rc 1 but ignored 0 40s elapsed findstr n ORA log gt errm txt 9 10 failed with rc 1 but ignored 0 23s elapsed findstr n SQLY Loader gt gt errm txt 10 10 failed with rc 1 but ignored 0 22s elapsed findstr n 75 7 log gt gt errm txt The process spent 11 334s and passed over a prescribed section 1 time s k Completed successfully 1 C XProgramDataYPLUMS I XXmtu 4 2Yx86 gt a Reload bat MPX mpx exe MPX
366. blp txt trace log lt gt lt gt lt gt MTU_USER_DIR input 1 lt gt lt gt OPLUMSIX Co Ltd LISTTABLE LOADMETHOD LONGTRANSIT MAXLONGSIZE MERGE LOBS INTO SDF METADIV MIN BULK SIZE MINIDUMP TYPE MINIMUM FREE SIZE MNGSCROUT NMENCLS NOBYTEORDERMARK NUM ASYNCLOBS NUM ROWS NUMBER2BCD NUMDAYS AUDIT OPTIMIZER HINTS OPTIMIZER MODE OUTPUT OVERLAP BUFFER LENGTH PARALLELISM PARTITIONING PRINTCOLID PRIORITY CLASS PRE REP EXEC PLS POST REP EXEC PLS QUERYFIX QUERYVAR QUERYFILENAME RECLENGTH RECOVERABLE RERUNPOINT REVERSEBYTEORDER ROWID SPLIT MIN SIZE ROWID SPLIT NUM PARTS ROWS ROWSEPARATOR SERVEROUTPUT SHOWCLTDTM SHOWSTAT SHOWSTMT SHOWVERS SKIPSCR SORTING SORT AREA SIZE v4 2 3 s D i s a b AR TRUNCATE 0 1000 iR iR 100 0x0 1024M 0xec00 true iR PARALLELISM 1 iR iR iR Rm MTU USER DIR output 1M 4 true true BELOW NORMAL Rm iR qryfix qryvar m iR 0M 4 true iR iR iR true iR m Rm iR OPLUMSIX Co Ltd C C n n s s D E i n S a a b b e e SQLFMT 0x8000 SRC_USER scott STDOUT 0x0000 STREAM LOCATOR Rm DELAY TIME 60 TERMINATOR TIMESTAMP MASK
367. cle wor Id v3 06 15 128 set USERID Quser id crd 8 9 EXCEPTION 4 5 2 18 DB EXCEPTIONS EXCEPTIONS 2 SCOTT 2 rdbms admin utlsampl sql Oracle Oracle Database Net Services 10g 2 10 2 v4 2 3 47 OPLUMSIX Co Ltd select owner substrb object 1 30 as object name object type status from all objects where object name EXCEPTIONS EXCEPTIONS
368. e10g first rows 1 first rows 10 first rows 100 first rows 1000 first rows all rows UNC C Documents and Settings UnLoad Query SQL Loader GetMeta meta sql UnLoad Query VO OVERLAP_BUFFER_LENGTH OVERLAP_BUFFER_LENGTH 256M
369. ery Unload B d X 7 7 v4 2 3 69 OPLUMSIX Co Ltd 1 11 1 PLUMSIX Env bat RELEY d mtu v4 1 64 bit BER GetMeta 4 Query EET 8 4d P x P i 11 2 11 2 1
370. ger create table v4 2 3 182 PLUMSIX Co Ltd ORGANIZATION EXTERNAL TYPE ORACLE LOADER DEFAULT DIRECTORY ALIAST 27 5 v4 16 27 5 1 FILETRACE 83 OUTPUT 5 10 2 dmp
371. l amp Pentium 1GB RAM 10 GB 1024 x 768 CD ROM Microsoft Visual Studio 2013 Visual C 7 URL Visual Studio 2013 Visual http www microsoft com ja jp download details aspx id 40784 URL CD R 30 Visual Studio 2013 Visual 190 8 MTU Oracle 32 O
372. lly immediate disable novalidate constraint FK DEPTNO foreign key 0008 DEPTNO references DEPT 0001 DEPTNO not deferrable initially immediate disable novalidate pctfree 10 pctused 40 initrans 1 maxtrans 255 nocache parallel degree 1 instances 1 tablespace SYSTEM storage initial 64k minextents 1 maxextents unlimited freelists 1 freelist groups 1 buffer pool DEFAULT v4 2 3 189 PLUMSIX Co Ltd 30 Visual Studio 2013 Visual C 7 31 BB Microsoft Visual C 2013 Redistributable
373. mm dd select from emp where job MANAGER and hiredate gt to date b hiredate yyyy mm dd select from emp where job PRESIDENT and hiredate gt to date b hiredate yyyy mm dd select from emp where job SALESMAN and hiredate gt to date b hiredate yyyy mm dd PARTITIONING 89 1 X sql PARTITIONING 1 0 X dat X nnnnnn dat 1 X mm dat X mm_nnnnnn dat mm 01 2 100 mm
374. n32API Code 0x70 Msg rcChkWin32Api O rcChkWin32Api c 30 rcWriteFile cFile c 576 rcPostFetchAction psGetData cUnLoadUnit c 3489 rcSelectIntoVector cOciStmt c 802 rcExecDefineAndFetch cOciStmt c 1019 Waiting v4 2 3 177 PLUMSIX Co Ltd Synchronized POOL STATISTICS Executing Error 1 rcSynchronizeSvc cOciSvc c 1414 rcPostRepGetData psGetDataYcC1021 c 2016 Waiting Synchronized Error 1 rcSynchronizeSvc c0OciSvc c 1414 rcForEachExList cList c 397 rcGetData psGetDataYcC1021 c 2127 rcUnLoad psGetData rcUnLoad 71 1 60
375. r of NUMA nodes 1 Number of physical processor packages 1 Number of processor cores 2 Number of logical processors 2 Number of processor L1 L2 L3 caches 4 1 0 ID 838 JA16SJISTILDE xXXxXXXXXXXXXXX SYSTEM Oracle Database 10g Enterprise Edition Release 10 2 0 3 0 64bit Production With the Partitioning OLAP and Data Mining options SYSTEM xxxxx xxxxxxX XXXXXXXXXXXXXX DEDICATED I 4013368 2012 03 08 11 56 56 G SCOTT SYSTEM APLDDPO1 PACKAGE APLDDTO1 TABLE APLDDT02 TABLE APLDDT03 TABLE APLDDT04 TABLE v4 2 3 49 OPLUMSIX Co Ltd c YProgramDataYPLUMSIXYmtu 4 2Xx64X inputY connect sql
376. racle v4 2 3 31 PLUMSIX Co Ltd 8 MTU Oracle Oracle Oracle Database 10gR2 11g 12c Enterprise Edition Standard Edition 10gR2 11g 12c Standard Edition One Personal Edition Oracle Client 10gR2 11g 12c Oracle Instant Client 10gR2 11g Oracle 8i Release 8 1 7 OS bit Oracle Database 8i Oracle 11g Client MTU My Oracle Support x64 Windows x86 WOW64 32
377. racle 7 SYSTEM 8 5 SQL Plus 7 CREATE USER v4 2 3 45 OPLUMSIX Co Ltd SQL select from session privs where privilege CREATE PROCEDURE CREATE ANY PROCEDURE select from session privs where privilege in CREATE TABLE CREATE ANY TABLE 1 DB JE DBA
378. sal lt b_sal key value value TH 0 FILEEXCPT INPUT 83 FILEFIXED LISTTABLE 84 El FILETABLE 82
379. t from emp where job b_job and sal gt b and hiredate gt to date b hiredate yyyy mm dd SQL Loader 3 DEPT i 4 002 197 128 Synchronized Error 1 rcSynchronizeSvc cOciSvc c 1414 rcPostRepGetData psGetData cC1021 c 2016 Waiting Synchronized v4 2 3 PLUMSIX Co Ltd Error 1 rcSynchronizeSvc cOciSvc c 1414 rcForEachExList cList c 397 rcGetData psGetDataYcC1021 c 2127 rcQuery psGetData rcQuery c 34 kbytes 0 44 0 59 kbytes 0 75 1004 C ProgramData PLUMSIXWntu_4 2Yx86 Query SQL INPUT
380. u v4 2 bit GetMeta Query Unload 07 43 _ em i Env bat J Env bat 48 OUTPUT 89 B X A 2 MTU_USER_DIR input mkdir 8 4 O
381. v4 2 3 154 PLUMSIX Co Ltd 4 lt gt FILEFIXED 81 B 22 2 Query Query 1 lt gt QUERYFIX 91 SELECT SAM 22 3 Unload Query 1 lt gt ROWSEPARATOR 95 0x00 2 lt gt NUMBER2BCD 88 Oracle Database NUMBER BCD 3 lt gt CHARSETFORM 75 2
382. xx WOW64 32 bit ProgramFiles ProgramFiles x86 VSALLUSERSPROF I LEXXPLUMS DXYmtu x xx yyy xxx yyy x86 x64 MTU_EXEC_DIR_X86 EXEC DIR X64 MTU_USER_DIR_X86 MTU USER DIR X64 11 bit 32 MTU EXEC DIR X86 ProgramFiles PLUMSIX mtu_4 2 x86 WOW64 Program

マルチ・スレッド・アンローダーバージョン 4.2.3 取扱説明書 2015 年 3 月

Contents

Download Pdf Manuals

Related Search

Related Contents

マルチ・スレッド・アンローダー バージョン 4.2.3 取扱説明書 2015 年 3 月

Contents

Download Pdf Manuals

Related Search

Related Contents

マルチ・スレッド・アンローダーバージョン 4.2.3 取扱説明書 2015 年 3 月