× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2014-10-10T07:03:58Z  · tariqrahiman last modified 2014-12-10T19:01:08Z

Oracle 12c -> Can we provide validation message when user create bitmap index with reverse option enable from UI side??


Priority Low
Complexity Unknown
Component DB - Oracle
Version 16.0
 
Product: Aqua Data Studio
Version: 15.0.7-31
Build #: 40547
Build Date: 2014-Oct-09 03:08:25 PM
 
Operating Environment: Windows 8 (6.2, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=954,728,448;  Total=545,783,808;  Free=372,154,768;  CPUs=8
 
 
Steps to Reproduce:
 
1.Connect to Oracle12c DB.
 
2.Create the below table:
 
 
CREATE TABLE "C##ABHISHEK1"."project"  ( 
"student_id"   VARCHAR2(25) NULL,
"student_name" VARCHAR2(25) NULL 
)
GO
 
 
Table created successfully.
 
Select Index option from the tree node,right click on it and select option Create Index
 
Fill the below credential in create index window:
 
Schema : Select the schema from schema drop down list.
Name:project_index
 
Go to Index to Table pane:
Schema : Select the schema from schema drop down list.
Name:project_index
 
Go to Index Columns pane and click on one of the rows sequence columns ,sequence number is assigned .
 
Go to the options tab,enable "Bitmap" and  "Reverse" options.
 
Go to Preview Sql Tab below script is  generated :
 
 
CREATE INDEX "C##ABHISHEK1"."project_index"
ON "C##ABHISHEK1"."project"("student_id", "student_name")
 
Click on Create button.
 
Observation:
Here it is observed that when we enable bitmap option along with reverse option and click on Create button,it allows to create bitmap index with reverse index option and
no validation message is displayed--> " ORA-28605: bitmap indexes cannot be reversed".
 
Execute the below script on query analyzer window:
 
CREATE INDEX "C##ABHISHEK1"."project_index"
ON "C##ABHISHEK1"."project"("student_id", "student_name")
 
Reverse
 
When we execute the script it display the error message -->" ORA-28605: bitmap indexes cannot be reversed".
 
Can we display validation message when user tries to create bitmap index with reverse option enable from UI side??
OR
Can we disable reverse option when we select bitmap index from UI side of create index window.
 
 
1 attachment

Issue #12544

Closed
Won't Fix
Resolved 2014-12-10T19:01:08Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017