Microsoft Word - J doc

Size: px

Start display at page:

Download "Microsoft Word - J doc"

ゆりなさどひら
4 years ago
Views:

1 SQL*Plus for Windows : J : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Oracle Oracle Corporation Oracle7 Oracle8i PL/SQL SQL*Plus Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved

2 Document CD-ROM... 4 README Windows Windows 95 TCP/IP... 8 Windows Terminal Server Oracle Universal Installer... 9 FAT NTFS Oracle Provider for OLE DB R Microsoft Visual Basic Microsoft Visual C SQL*Plus for Windows

3 8.1.6 Windows 2000 Windows 95 TCP/IP Windows Terminal Server 3

4 Oracle8i Release 2 Release R8.1.6 Oracle8i URL Document CD-ROM Oracle8i for Windows NT E CD-ROM README %ORACLE_HOME% relnotes README README README README CD 4 SQL*Plus for Windows

5 8.1.6 Oracle8i Client Net8 Products Net8 Client Oracle Protocol Support Oracle TCP/IP Protocol Support Oracle Named Pipes Protocol Support Oracle SPX/IPX Protocol Support Oracle LU6.2 Protocol Support *(1) Oracle Utilities Oracle Performance Monitor for Windows NT *(3) Oracle Database Utilities SQL*Plus Oracle Java Products Oracle JDBC drivers Oracle JDBC/OCI Driver for JDK Oracle JDBC/OCI Driver for JDK Oracle JDBC/Thin Driver for JDK Oracle JDBC/Thin Driver for JDK Oracle SQLJ Oracle Java Tools Oracle Programmer Development Tools Oracle Call Interface (OCI) Object Type Translator Oracle Objects for OLE Oracle Objects for OLE Oracle ODBC Driver Oracle Provider for OLE DB Pro*C/C Pro*COBOL Pro*COBOL

6 Oracle Enterprise Manager Products Oracle Enterprise Manager Client Oracle Enterprise Manager Console Oracle Enterprise Manager Integrated Applications Oracle intermedia Text Manager Oracle Enterprise Security Manager Oracle Developer Server Forms Manager Net8 Integration *(4) Oracle Application Server Manager *(4) Oracle Parallel Server Manager Oracle Replication Manager Oracle Spatial Index Advisor Beta *(2) Oracle Directory Server Manager Oracle Applications Manager Oracle Enterprise Manager Migration Assistant Oracle DBA Management Pack Oracle Schema Manager Oracle Storage Manager Oracle Security Manager Oracle Instance Manager SQL*Plus Worksheet Oracle DBA Studio Oracle Enterprise Manager Quick Tours Oracle DBA Management Pack Quick Tour Oracle Enterprise Manager Quick Tour Oracle Installation Products Oracle Universal Installer Oracle AppWizards for Microsoft Visual Studio Oracle AppWizard for Microsoft Visual C *(5) Oracle Migration Workbench *(1) MS Access Plugin *(1) MS SQL Server 6.5 Plugin *(1) MS SQL Server 7.0 Plugin *(1) Sybase Adaptive Server 11 Plugin *(1) 6 SQL*Plus for Windows

7 Oracle Services for Microsoft Transaction Server *(3) Oracle Advanced Security Oracle intermedia Client Option Oracle Visual Information Retrieval Client *(1) Oracle Internet Directory Client : SQL*Plus for Windows R8.1.6 *(1) *(2) *(3) Oracle8i Client Windows NT/2000 *(4) Oracle8i Client Windows NT *(5) Microsoft Visual C

8 Windows 2000 SQL*Plus for Windows Windows 2000 Windows 95 TCP/IP Oracle TCP/IP Protocol Support for Windows 95/98 Windows Sockets 2 Windows 95 SQL*Plus for Windows Windows Socket 2 Update for Windows 95 Microsoft Web Windows Socket 2 Update for Windows 95 CD-ROM WINSOCK2 WS2SETUP.EXE Windows Socket 2 Update for Windows 95 TCP/IP Web Windows 95 Windows Socket 2 Update for Windows 95 TCP/IP 1.3 Oracle Oracle TCP/IP Protocol Adapter Windows Sockets /8.0.4 Windows Socket 2 Update for Windows Windows Terminal Server Windows NT Terminal Server Edition Windows 2000 Server 8 SQL*Plus for Windows

9 Oracle Universal Installer PATH 1024 Oracle PATH PATH PATH OK [Ctrl]+[Alt]+[Delete] EXPLORER.EXE CONTROL.EXE PATH OS Loader Last Known Good Menu Windows NT Last Known Good Menu Oracle Oracle Universal Installer (OUI) 1.7.x Windows NT NetWare CD-ROM Windows NT Oracle Universal Installer Java Runtime Environment <location> Oracle Universal Installer Novell JRE_LOCATION 8 9

10 CD-ROM Windows NT Oracle Universal Installer Windows NT 4.0 SP5 ATI Oracle Universal Installer Windows NT Oracle Universal Installer 2 Oracle8i 1. Oracle8i Oracle Universal Installer 2 Java Runtime Environment JRE Oracle8i JRE Oracle8i JRE Oracle8i Oracle Enterprise Manager 2.0 Oracle8i Oracle Enterprise Manager 2.1 JRE Oracle Universal Installer Oracle8i Oracle Enterprise Manager 2.1 JRE JRE SQL*Plus for Windows 10 SQL*Plus for Windows

11 8.1.6 CD-ROM Oracle Provider for OLE DB COM Oracle 1 Oracle Provider for OLE DB 1 Oracle Provider for OLE DB Oracle Universal Installer Microsoft <filename>.dll.old Oracle Universal Installer <filename>.dll.old <filename>.old msvcrt.dll msvcirt.dll msvcrt40.dll oleaut32.dll olepro32.dll mfc40.dll mfc42u.dll mfc42.dll Novell Client for Windows NT Oracle Universal Installer Windows 95/98 autoexec.bat path Bug# path 11

12 2. autoexec.bat.old0 %ORACLE_HOME% bin path FAT NTFS FAT NTFS FAT Oracle Universal Installer FAT 32K NTFS 2K Oracle8i Client RAM FAT NTFS 64MB 678MB 236MB 19MB 32MB 164MB 102MB 16MB 32MB 93MB 48MB 16MB README "xxx" 12 SQL*Plus for Windows

13 EPC OCI ORA ORA ORA ORA ORA ORA 'xxx' 'xxx' OracleNUMBER xxx xxx 'xxx' 'xxx' Oracle Number PRIORITY xxx.xxx [xxx] 'xxx' 'xxx' Oracle xxx xxx 'xxx' 'xxx' Oracle SEQUENCE_DEVIATION PRIORITY xxx.xxx SEQUENCE_DEVIATION [xxx] 13

14 Oracle Provider for OLE DB R : Oracle Provider for OLE DB Windows 95 OraOLEDB COM ORACLE 1 1 OraOLEDB OraOLEDB OraOLEDB Microsoft Visual Basic 6.0 Microsoft ActiveX Data Objects Microsoft ActiveX Data Objects Recordset Microsoft Visual C VC++.cpp OraOLEDB.h.cpp 1 #define DBINTCONSTANTS JOIN ADO ADO Dim objcon As New ADODB.Connection Dim objrst As New ADODB.Recordset objcon.provider = "OraOLEDB.Oracle" objcon.open "db815", "scott", "tiger" 14 SQL*Plus for Windows

15 objrst.cursorlocation = aduseclient 'ADO Client Cursor objrst.open "select ename, dname " & _ "from emp, dept " & _ "where emp.deptno = dept.deptno", _ objcon, adopenstatic, adlockoptimistic, adcmdtext JOIN CursorLocation aduseclient 1.2 CursorLocation aduseclient Client Cursor ADO LOB /LONG aduseserver 1.3 ADO CacheSize ADO FetchSize ConnectionString Oracle Provider for OLE DB CacheSize FetchSize < 1 FetchSize ADO LOB / INSERT/UPDATE SQL LONG LONG RAW ADO AppendChunk ADO AddNew ADO Update LONG LONG RAW 2.2 COMMIT ROLLBACK SAVEPOINT SQL DDL CREATE TABLE ALTER VIEW Oracle DDL DDL 2.3 Oracle EMP emp 2 Oracle Provider for OLE DB R

16 SQL SELECT ename FROM emp EMP SELECT ename FROM "Emp" Emp Oracle 2.4 OraOLEDB /*+... */ LEVEL ROWID ROWNUM SQL SYSDATE UID USER SQL 2.6 BFILE BFILE INSERT INTO topomaps (areanum, topomap) VALUES (158, BFILENAME('mapdir', 'topo158.tps')) 2.8 Oracle8i 2.9 PL/SQL PROCEDURE_PARAMETERS PL/SQL / OLE DB / 2.10 LOB UPDATE SomeTable SET LobCol =?WHERE SQL*Plus for Windows

17 UPDATE LOB BLOB/CLOBLONG LONG/LONG RAW 2.11 LOB INSERT UPDATE LOB 2.12 Oracle 2.13 ADO GetChunk() ADO LOB LONG rst("lob_column").value ADO 2.14 OLE DB CONNECTIONSTATUS 3. OraOLEDB a. OLE DB HRESULT 3. ID b ID a. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceFileName Oracle Provider for OLE DB R

18 TraceFileName TraceOption 0 TraceOption 1 ID TraceOption b. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceCategory 0 = 1 = OLEDB 2 = OLEDB 4 = TraceCategory TraceCategory 3 c. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceLevel 0 = 1 = 2 = 4 = 8 = 16 = TraceLevel OLE DB OLE DB 1 OLE DB TraceLevel TraceLevel 12 TraceCategory 3 18 SQL*Plus for Windows

19 d. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceOption 0 = 1 = TraceOption ID 1 TraceFileName ID Oracle Provider for OLE DB R

Microsoft Word - J doc

Microsoft Word - J doc Oracle Objects for OLE for Windows 8.1.6.3.7 2000 5 : J01934-01 : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Objects for OLE R8.1.6.3.7