Neoview Database Administrator's Guide (R2.3)

Index
A
Access privileges, granting and revoking , 41, 50
Adding
columns to a table, 55, 56
indexes, 58
materialized view groups, 77
materialized views, 70
roles, 23
schemas, 36
tables, 43, 47
user IDs, 25
views, 67
Age table operation, 88
Automated REORG
description of, 103
scheduling, 107
Automated tables
listing, 105
setting, 103
Automated UPDATE STATISTICS
description of, 103
listing automated tables, 105
scheduling, 107
starting, 103
stopping, 107
C
Changing
materialized view groups, 79
materialized views, 76
passwords, roles, 23
passwords, user IDs, 26
synonyms, 81
tables
adding columns, 55
adding tables, 55
attributes, 56
renaming, 57
update statistics schedule, 91
changing
tables
attributes, 56
CHG_AUTO_LIST() stored procedure, 103
Client data sources
configuring, 111
reconfiguring, 111
removing, 111
Columns
adding to a table, 55, 56
displaying in a table, 51
Configuring client data sources, 111
CREATE INDEX statement, 31
CREATE TABLE statement, 31
Creating
indexes, 58
materialized view groups, 77
materialized views, 70, 73
roles, 23
schemas, 40
synonyms, 80
tables, 43
tables from existing tables, 47
user IDs, 25
views, 67
D
Data
recovery, 93
Data source
displaying names, 111
for update operations, 111
reconfiguring, 111
removing ODBC, 111
Database events, viewing, 97, 99
DB Admin Tool
starting, 17
DB Admin tool, overview, 17
DB schema
creating tables, 21, 22
description of, 17, 36
DDL
displaying for indexes, 62
displaying for materialized view groups, 78
displaying for materialized views, 76
displaying for schemas, 41
displaying for tables, 54
displaying for views, 69
importing from files, 48
Default table sizes, 31
Defragment indexes operation, 87
Defragment materialized views operation, 87
Defragment table operation, 87
Deleting
roles, 24
user IDs, 27
Deleting (dropping)
indexes, 62
materialized view groups, 79
materialized views, 77
schemas, 42
synonyms, 82
tables, 58
views, 70
Dial-out events, viewing, 96, 99
Displaying
columns in a table, 51
DDL for indexes, 62
DDL for materialized view groups, 78
DDL for materialized views, 75, 76
DDL for schemas, 41
DDL for synonyms, 81
127