JQL INDEX ISSUE
- Azizfatkh
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 35
- Thank you received: 0
12 years 1 month ago #12788
by Azizfatkh
JQL INDEX ISSUE was created by Azizfatkh
Good day everyone! Can anyone help with this case? Thanks in advance!
jsh dev2 ~ -->CREATE-INDEX -c FBNK.CUSTOMER SH.NAME BY SHORT.NAME
Notice: Command converted to 'CREATE-INDEX -c FBNK.CUSTOMER SH.NAME BY-AL 2'
Index definition 'SH.NAME' created successfully
jsh dev2 ~ -->KEY-SELECT FBNK.CUSTOMER WITH SH.NAME LIKE ...MM...
Fatal error: The index is not in sync. -- use rebuild-index
jsh dev2 ~ -->REBUILD-INDEX -a FBNK.CUSTOMER
jsh dev2 ~ -->
jsh dev2 ~ -->KEY-SELECT FBNK.CUSTOMER WITH SH.NAME LIKE ...MM...
Fatal error: The index is not in sync. -- use rebuild-index
System : AIX t24oracle-node1 1.6 00F70EFA4C00
OS Release : 6.1.7.0
UNIX User : dev7 (uid 307, euid 307)
Tty name : /dev/pts/7
Time : Tue Oct 9 16:12:33 2012
Please Log in or Create an account to join the conversation.
- wam
- Offline
- Senior Member
Less
More
- Posts: 55
- Thank you received: 3
12 years 1 month ago #12794
by wam
Replied by wam on topic JQL INDEX ISSUE
Are you using Oracle as Database or jBASE.
If its Oracle then you can't create index like this.
If its Oracle then you can't create index like this.
Please Log in or Create an account to join the conversation.
- Azizfatkh
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 35
- Thank you received: 0
12 years 1 month ago #12795
by Azizfatkh
Replied by Azizfatkh on topic JQL INDEX ISSUE
Yes, its oracle database. Is there another way to do like this?
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
12 years 1 month ago #12797
by jpb
Replied by jpb on topic JQL INDEX ISSUE
CREATE-EXTINDEX
See UserGuide "Oracle Installation"
See UserGuide "Oracle Installation"
Please Log in or Create an account to join the conversation.
Time to create page: 0.072 seconds