Aqua Data Studio 15.0.0-dev-37
Database Version:Oracle11g
Build #: 34859
Built on: 2013-Nov-14 02:04:45 PM
Connect to Oracle11g Database
Go to schema c##project -->Go to Index option--->Right click on it --->Create Index.
Under General Tab fill the following information:
Schema:Select Schema c##project from the drop down list.
Name:Enter index name aemployee.
Go to Index on Table Pane.
Schema:Select Schema c##project
Table:employee
Go to Indexed to columns
Assign order ascending to col1 and to rest of the column assign order descending .
Click on create index option.
Now go to index node option under oracle database,expand it-->select index aemployee-->Right click on it-->Select Option Alter Index.
Here it is observe that the columns on which order descending was applied,its datatypes are not missing in datatype option.
Column c1 c2 c3 are marked in doubles quotes "c2","c3","c4".
Now go to script to window as -->Select option create full.
CREATE INDEX "c##project"."aemployee"
ON "c##project"."employee"("col1", ""c2"" DESC, ""c3"" DESC, ""c4"" DESC)
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
VISIBLE
NOPARALLEL
LOGGING
GO
Here it is observe that double quotes are added before column and after column c2,c3,c4 on which order descending is applied.
