invalid feild definiton error [message #39562] |
Tue, 23 July 2002 12:23 |
Laura Chastain
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Why does Oracle 8.1.6 rename the column in an index when you use desc after the column name in the create index statement. Here is an example of the create index statement:
create index lbcdba.testindx on lbcdba.pdcuser
(domain_name, server_type desc)
pctfree 5 tablespace lawsp_indx storage(initial 16k next 16k pctincrease 0) nologging;
When we queried dba_ind_columns it shows the column name for server_type as SYS_NC00006$.
If this index is used as a hint in the application we get and error "invalid field definition 'SYS_NC00006$' in definition of index or relationship." We are not sure how to fix this problem or why Oracle renames the column. Can anyone at least explain the 'desc' usage and why oracle renames the column in the data dictionary?
|
|
|
Re: invalid feild definiton error [message #39563 is a reply to message #39562] |
Tue, 23 July 2002 12:56 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
is that a lob colum you are concerned about???
if so,
you need to specify lobindex exclusively
along with the defnintion of the table.
something like
Create table mytable ( A number, B clob )
LOB(b)
STORE AS lobsegmentname (
TABLESPACE lobtablespace
STORAGE (storage clause)
INDEX lobindexname (
TABLESPACE lobindextbs
STORAGE ( storage clause )
)
)
TABLESPACE tables_ts
STORAGE( storage clause )
|
|
|