Neoview Database Administrator's Guide (R2.3)

Scripting, 18
Security
considerations, 15
managing policies, 29
STOP_AUTOMATED_STATS() stored procedure, 107
Stored procedures, 18, 82
Sun Java Plug-in, supported versions, 16
Super ID, managing, 95
Support, contacting, 13, 93
Synonyms
changing, 81
creating, 80
displaying, 81
displaying DDL, 81
dropping (deleting), 82
System messages, viewing, 96
System name display, 18
System status page (Neoview VTS), 91
T
Tables
adding columns to, 55, 56
ageing operation, 88
changing, 55, 56
adding columns, 55
attributes, 56
renaming, 57
changing materialized view groups for, 79
creating, 43
creating from existing tables, 47
creating index for, 58
creating materialized view groups for, 77
creating materialized views for, 70, 73
creating multiple, 49
creating synonyms for, 80
creating triggers on, 63
creating using existing tables, 47
creating views for, 67
defaults, 31
defragmenting, 87
deleting (dropping) indexes, 62
deleting (dropping) synonyms, 82
deleting (dropping) views, 70
displaying DDL, 54
displaying indexes for, 62
displaying materialized view groups for, 78
displaying materialized views for, 75
displaying properties, 51
displaying synonyms for, 81
displaying views for, 68
dropping (deleting), 58
dropping (deleting) indexes, 62
dropping (deleting) synonyms, 82
dropping (deleting) views, 70
enabling or disabling triggers on, 58, 67
granting/revoking access privileges, 50
limits, 33
maintaining, 85
populating index, 31
renaming, 57
side defaults, 31
triggers, 63
update statistics, 87
Tape device, 91
Triggers
creating, 63
description of, 63
displaying properties, 66
Troubleshooting, overview of where to look for solutions,
13
U
Uninstalling ODBC client data sources, 111
Update statistics operation
automating, 103
(see also Automated UPDATE STATISTICS)
modifying, 91
scheduling, 87, 107
User IDs
changing passwords and expiration dates, 26
creating, 25
deleting, 27
managing security policies, 29
preconfigured, 21
typical usage, 22
viewing status, 28
User status, viewing, 28
USR schema
creating tables, 21, 22
description of, 17, 36
USTAT_AUTO_LIST view, 106
USTAT_AUTO_LIST_DETAIL view, 106
V
Viewing user status, 28
Views
changing materialized, 76
changing materialized view groups, 79
creating, 67
creating materialized, 70, 73
creating materialized view groups, 77
displaying, 68
displaying DDL, 69, 76
displaying materialized view groups, 78
dropping (deleting), 70
dropping (deleting) materialized, 77
dropping materialized view groups, 79
renaming, 69
Virtual tape server (VTS), 91
W
Wizards
Alter Materialized View Group, 79
Alter Synonym, 81
Create Index, 58
Create Materialized View, 70, 73
Create Materialized View Group, 77
Create Schema, 40
131