Neoview Database Administrator's Guide (R2.2)

Index
Symbols
.bad file, 116
.rcvy file, 117
A
Access privileges, granting and revoking , 47
Accounts, Linux
adding, 18, 31
creating, 18, 31
deleting, 18, 31
description of, 18
resetting passwords, 30
thawing, 31
Adding
columns to a table, 51, 52
indexes, 57
Linux accounts, 18, 31
materialized view groups, 69
materialized views, 63
roles, 25
schemas, 38
tables, 40, 44
user IDs, 27
views, 60
Age table operation, 80
B
Backups, data, 84
C
Changing
Linux accounts, 30
materialized view groups, 71
materialized views, 68
passwords, roles, 25
passwords, user IDs, 27
synonyms, 73
tables
adding columns, 51
adding tables, 51
attributes, 52
renaming, 52
update statistics schedule, 83
changing
tables
attributes, 52
Client data sources
configuring, 135
reconfiguring, 135
removing, 135
Columns
adding to a table, 51, 52
displaying in a table, 47
Configuring client data sources, 135
CREATE INDEX statement, 33
CREATE TABLE statement, 33
Creating
indexes, 57
Linux accounts, 18, 31
materialized view groups, 69
materialized views, 63, 65
roles, 25
schemas, 39
synonyms, 72
tables, 40
tables from existing tables, 44
user IDs, 27
views, 60
D
Data
backups, 84
recovery, 85
Data source
displaying names, 135
for update operations, 135
reconfiguring, 135
removing ODBC, 135
Database events, viewing, 88, 90
DB Admin Tool
startomg, 19
DB Admin tool, overview, 19
DB schema
creating tables, 23, 24
description of, 20, 38
DDL
displaying for indexes, 60
displaying for materialized view groups, 71
displaying for materialized views, 68
displaying for schemas, 39
displaying for tables, 51
displaying for views, 62
importing from files, 45
Default table sizes, 33
Defragment indexes operation, 78
Defragment materialized views operation, 79
Defragment table operation, 78
Deleting
Linux accounts, 18, 31
roles, 26
user IDs, 28
Deleting (dropping)
indexes, 60
materialized view groups, 71
materialized views, 69
schemas, 40
synonyms, 74
tables, 56
views, 62, 63
Delimiters, nonprinting characters, 111
Dial-out events, viewing, 88, 90
151