Neoview Database Administrator's Guide (R2.4)

view events, 101
viewing user status, 29
viewing user status by role, 30
views
creating, 70
displaying, 71
entering DDL to create, 70
renaming, 71
virtual tape status, 94
VST system status page, 94
Scripting, 19
Security
considerations, 16
managing policies, 30
STOP_AUTOMATED_STATS() stored procedure, 109
Stored procedures, 19, 84
Sun Java Plug-in, supported versions, 16
Super ID, managing, 97
Support, contacting, 13, 95
Synonyms
changing, 83
creating, 82
displaying, 83
displaying DDL, 83
dropping (deleting), 84
System messages, viewing, 98
System name display, 19
System status page (Neoview VTS), 93
T
Tables
adding columns to, 57, 58
changing, 57, 58
adding columns, 57
attributes, 58
columns, 59
renaming, 59
changing columns, 59
changing materialized view groups for, 81
creating, 45
creating from existing tables, 49
creating index for, 61
creating materialized view groups for, 79
creating materialized views for, 72, 75
creating multiple, 51
creating synonyms for, 82
creating triggers on, 65
creating using existing tables, 49
creating views for, 69
defaults, 33
defragmenting, 89
deleting (dropping) indexes, 64
deleting (dropping) synonyms, 84
deleting (dropping) views, 72
displaying DDL, 56
displaying indexes for, 64
displaying materialized view groups for, 80
displaying materialized views for, 77
displaying properties, 53
displaying synonyms for, 83
displaying views for, 70
dropping (deleting), 60
dropping (deleting) indexes, 64
dropping (deleting) synonyms, 84
dropping (deleting) views, 72
enabling or disabling triggers on, 60, 69
granting/revoking access privileges, 52
limits, 35
maintaining, 87
populating index, 33
purgeing, 90
renaming, 59
side defaults, 33
triggers, 65
update statistics, 89
Tape device, 93
Triggers
creating, 65
description of, 65
displaying properties, 68
Troubleshooting, overview of where to look for solutions,
13
U
Uninstalling ODBC client data sources, 113
Update statistics operation
automating, 105
(see also Automated UPDATE STATISTICS)
modifying, 93
scheduling, 89, 110
User IDs
changing passwords and expiration dates, 27
creating, 26
deleting, 28
managing security policies, 30
preconfigured, 21
typical usage, 22
viewing status, 29
User status, viewing, 29
USR schema
creating tables, 21, 22
description of, 18, 38
USTAT_AUTO_LIST view, 108
USTAT_AUTO_LIST_DETAIL view, 108
V
Viewing user status, 29
Views
changing materialized, 78
changing materialized view groups, 81
creating, 69
creating materialized, 72, 75
creating materialized view groups, 79
displaying, 70
displaying DDL, 71, 78
displaying materialized view groups, 80
dropping (deleting), 72
dropping (deleting) materialized, 79
141