5
Database Administration
Call Data Tables
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 212
4
Enter
create unique index index_name on table_name (“FIELD1”);
The system creates a unique index for FIELD1 in the table.
Non-Unique Indexes
Non-unique indexes do not prevent the same data from appearing in that field
in several records in the same table. For example, if a field contains the area
code of a telephone number and an index is created for that field, it must be a
non-unique index since other records may require the same number in their
area code field.
Use the following procedure to create non-unique indexes on fields called
FIELD1
and
FIELD2
in a table called
table_name
:
1
At the
Console Login:
prompt, enter root
The system prompts you for a password.
2
Enter your root password.
The system displays the system prompt
#
.
3
Enter sqlplus sti/sti
The system starts a sqlplus session.
4
Enter create index index_name on table_name (“FIELD1”);
The system creates a non-unique index for FIELD1 in the table.
Содержание R4.2
Страница 1: ...UCS 1000 R4 2...
Страница 2: ...Copyright 2000 by Lucent Technologies All rights reserved...
Страница 21: ...vusage 618 wl_copy 619 wl_edit 620 wl_gen 622 wl_init 624 wl_install 625 Glossary 627 Index 699...
Страница 192: ...4 Switch Interface Administration Digital Interfaces Figure 89 Assign Card T1 A B Robbed bit E M Window...
Страница 313: ...6 Peripheral Administration Modem Administration 10 Select ModemMon add to one add port services...
Страница 665: ...A Summary of Commands wl_install Example wl_install See Also wl_copy wl_gen...