Neoview Database Administrator's Guide (R2.2)

creating using existing tables, 44
creating views for, 60
defaults, 33
defragmenting, 78
deleting (dropping) indexes, 60
deleting (dropping) synonyms, 74
deleting (dropping) views, 62
deleting rows, 80
displaying DDL, 51
displaying indexes for, 59
displaying materialized view groups for, 70
displaying materialized views for, 67
displaying properties, 47
displaying synonyms for, 73
displaying views for, 61
dropping (deleting), 56
dropping (deleting) indexes, 60
dropping (deleting) synonyms, 74
dropping (deleting) views, 62
enabling or disabling triggers on, 56
granting/revoking access privileges, 47
limits, 35
maintaining, 77
populating index, 33
renaming, 52
side defaults, 33
triggers, 53
update statistics, 78
Tape device, 84
Triggers
creating, 53
description of, 53
Troubleshooting, overview of where to look for solutions,
16
U
Uninstalling ODBC client data sources, 135
Update statistics operation
modifying, 83
scheduling, 78
User IDs
changing passwords and expiration dates, 27
creating, 27
deleting, 28
managing security policies, 29
preconfigured, 23
typical usage, 24
viewing status, 29
User status, viewing, 29
Useradmin account, description of, 18, 30
USR schema
creating tables, 23, 24
description of, 20, 38
V
Viewing user status, 29
Views
changing materialized, 68
changing materialized view groups, 71
creating, 60
creating materialized, 63, 65
creating materialized view groups, 69
displaying, 61
displaying DDL, 62, 68
displaying materialized view groups, 70
dropping (deleting), 62
dropping (deleting) materialized, 69
dropping materialized view groups, 71
renaming, 62
Virtual tape server (VTS), 84
W
Wizards
Alter Materialized View Group, 71
Alter Synonym, 73
Create Index, 57
Create Materialized View, 63, 65
Create Materialized View Group, 69
Create Schema, 39
Create Synonym, 72
Create Table, 40
Create Table Using, 44
Create Trigger, 54
Create View, 60
Rename Table, 53
Schedule Age Table, 81
Schedule Maintain, 77
156 Index