Neoview Database Administrator's Guide (R2.4)
Index
A
Access privileges, granting and revoking , 43, 52
Adding
columns to a table, 57, 58
indexes, 61
materialized view groups, 79
materialized views, 72
roles, 23
schemas, 38
tables, 45, 49
user IDs, 26
views, 69
Automated REORG
description of, 105
scheduling, 110
Automated tables
listing, 108
setting, 105
Automated UPDATE STATISTICS
description of, 105
listing automated tables, 108
scheduling, 110
starting, 105
stopping, 109
C
changePassword command
syntax of, 128
Changing
columns in a table, 59
materialized view groups, 81
materialized views, 78
passwords, roles, 24
passwords, user IDs, 27
synonyms, 83
tables
adding columns, 57
adding tables, 57
attributes, 58
columns, 59
renaming, 59
update statistics schedule, 93
changing
tables
attributes, 58
CHG_AUTO_LIST() stored procedure, 105
Client data sources
configuring, 113
reconfiguring, 113
removing, 113
Columns
adding to a table, 57, 58
changing, 59
displaying in a table, 53
Configuring client data sources, 113
CREATE INDEX statement, 33
CREATE TABLE statement, 33
createUser command
syntax of, 125
Creating
indexes, 61
materialized view groups, 79
materialized views, 72, 75
roles, 23
schemas, 42
synonyms, 82
tables, 45
tables from existing tables, 49
user IDs, 26
views, 69
D
Data
recovery, 95
Data source
displaying names, 113
for update operations, 113
reconfiguring, 113
removing ODBC, 113
Database events, viewing, 99, 101
DB Admin Tool
starting, 17
DB Admin tool, overview, 17
DB schema
creating tables, 21, 22
description of, 18, 38
DDL
displaying for indexes, 64
displaying for materialized view groups, 80
displaying for materialized views, 78
displaying for schemas, 43
displaying for tables, 56
displaying for views, 71
importing from files, 50
Default table sizes, 33
Defragment indexes operation, 89
Defragment materialized views operation, 89
Defragment table operation, 89
Deleting
roles, 25
user IDs, 28
Deleting (dropping)
indexes, 64
materialized view groups, 81
materialized views, 79
schemas, 44
synonyms, 84
tables, 60
views, 72
Dial-out events, viewing, 98, 101
Displaying
137