Oracle A423961 Manual do Utilizador Página 107
- Página / 202
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
SQL Ref.
5 – 11Database Administration
SQL*Language Conventions
The Oracle7 Server SQL Reference describes all aspects of Oracle’s
implementation of the SQL language. Certain features of SQL have
operating system–specific variations.
ROWID Datatype
The ROWID datatype provides a hexadecimal address of each row in a
database table. The format of the ROWID datatype is:
block.row.file
where block, row, and file are hexadecimal addresses that indicate the
data block, row, and database file of the queried row. The hexadecimal
lengths for block, row, and file, are eight, four, and four, respectively.
These lengths do not vary with Oracle7 Server for Windows NT.
Additional Information: See Oracle7 Server SQL Reference for
more information on the ROWID datatype.
- Release 7.3 1
- Audience 4
- How this Guide Is Organized 4
- Using the Documentation 5
- Monospace text 7
- Reader Comments 8
- Contents 9
- xiContents 11
- xiiiContents 13
- Introducing Oracle7 15
- Server for Windows NT 15
- Special Terms 16
- Feature Highlights 17
- Windows NT Services 20
- Security Features 20
- Server—Windows NT 22
- Oracle7 Server for Windows NT 22
- Oracle7 Utilities 22
- SQL*Plus 23
- Secure Network Services 23
- Required Support Files 23
- Client Software 23
- Oracle Networking Software 25
- SQL*Net Version 2 25
- Network Manager 25
- Installing Oracle7 27
- System Requirements—Server 28
- Software 29
- Windows on Win32 (WOW) 30
- Windows NT 30
- Before You Install 31
- Installation Types—Windows NT 32
- Programmer/2000 33
- Selective 34
- Windows NT Installations 35
- Using Oracle Installer 35
- Oracle7 Client 42
- Oracle Documentation 43
- Client System Requirements 44
- Hardware Requirements 44
- Software Requirements 44
- Configuring SQL*Net 48
- Overview 50
- Prepare for the Migration 50
- Install the Oracle7 Server 52
- Move Database Files 53
- SVRMGR> shutdown 57
- SVRMGR> startup 57
- Using Oracle7 Server 59
- What is an Instance? 60
- The Starter Database 60
- TMP1ORCL.ORA 62
- Oracle Services 63
- Instance Manager 64
- Changing Passwords 66
- Advanced Parameters 67
- Starting a Database 68
- C:\>SVRMGR73 69
- Delete an Instance 70
- Running Multiple Instances 70
- Using Server Manager 70
- Creating an Instance 71
- Starting an Instance 71
- Creating a New Database 72
- Run Server Mgr & 73
- C:\>SVRMGR73 [MODE=LINE] 74
- SQL Ref 75
- SET ORACLE_SID=ABC 76
- SVRMGR>@[path]filename 76
- Utilities 77
- Creating Database Objects 78
- Setting Resource Costs 78
- Using Export and Import 79
- Using SQL*Loader 80
- SQL*Loader Processing Options 80
- Control File Conventions 81
- Using the MONITOR Command 81
- –STARTUP 83
- –SHUTDOWN 83
- ORADIM Log 84
- Getting the Most out of 85
- Integration with 85
- Performance Monitor Objects 87
- Memory Allocation Objects 87
- Tuning I/O 88
- Tuning Contention 88
- Additional Tuning Contentions 88
- Event Viewer 89
- Database Security 89
- Database Password Encryption 90
- Creating Password Files 91
- NT GROUPS and ROLES 92
- OS_ROLES must be set to TRUE 93
- ORA_%SID%_ROLENAME[_[D][A]] 93
- • CONNECT / as sysdba 94
- • CONNECT / as sysoper 94
- • CONNECT INTERNAL 94
- Database 97
- Administration 97
- Backup Manager 98
- Hot Database File Backup 98
- Restoring Active Files 99
- Recovery Manager 100
- Using Trace and Alert Files 101
- Logging Error Messages 101
- Refreshing Table Snapshots 102
- Advanced Replication Option 103
- Master Site Parameters 105
- Setup Procedures 105
- Other Notes 106
- SQL*Language Conventions 107
- Documentation 109
- Documentation Catalog 110
- A – 3Documentation Roadmap 111
- Documentation Sets 113
- Installation Documentation 113
- Oracle7 Release Notes 113
- Oracle7 Tuning 115
- Oracle7 Server SQL Reference 115
- A – 9Documentation Roadmap 117
- Understanding SQL*Net 119
- Using Oracle Documentation 121
- Oracle7 Server 123
- Directory Structures 123
- Initialization Parameter 129
- Initialization Parameters 132
- Configuration 135
- Parameters and the 135
- Windows NT Registry 135
- C:\>REGEDT32 136
- General Parameters 137
- Networking Parameters 141
- NMP_SPAWN_INCREMENT 142
- Messages and Codes 145
- Installer Error Messages 146
- E – 3Messages and Codes 147
- E – 5Messages and Codes 149
- E – 7Messages and Codes 151
- E – 9Messages and Codes 153
- E – 11Messages and Codes 155
- E – 13Messages and Codes 157
- E – 15Messages and Codes 159
- E – 17Messages and Codes 161
- E – 19Messages and Codes 163
- E – 21Messages and Codes 165
- SQLNET ORASRV_WAIT = 166
- ORA_SRVTnn_[SID].OUT 166
- E – 23Messages and Codes 167
- E – 25Messages and Codes 169
- E – 27Messages and Codes 171
- E – 29Messages and Codes 173
- E – 31Messages and Codes 175
- National Language 177
- NLS_LANG 178
- Language Territory Charset 179
- Using ALTER SESSION 180
- Parameter Lists 181
- Territories 182
- Single–byte Character Sets 183
- Multi Byte Character Sets 184
- Language 185
- Language File 185
- Abbreviation 185
- Language Language File 185
- Index – 1 187
- Index – 3 189
- Index – 5 191
- Index – 7 193
- Index – 9 195
- Index – 11 197
- Index – 13 199
- Reader’s Comment Form 201
Manuais e produtos relacionados com Computadores Oracle A423961
Computadores Oracle A54857-03 Manual do Utilizador
(80 páginas)
(80 páginas)
© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.055 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais