Aqua Data Studio 15.0.0-dev-37
Database:Oracle 11g
1.Connect to Oracle 11g
Go to Schema object folder,expand it
Go to c##project schema,expand it
Go to Clusters object folder
Right click and select Create Cluster option
Create Cluster window get opened
2.In Create Cluster window
Select schema name c##project from drop down list
Enter cluster name trial_one
Enter size 0.58
Select Kilobyte(KB) from drop down list
Check Index Cluster option in Type pane
Go to Cluster Key Columns pane
Add column dept_no of NUMBER datatype
3.Go to Storage Tab
Select Tablespace as Users from drop down list
Enter values in General Pane as follows:
Initial Trans:2
Percent Free For Updates:10
Max Trans:255
Percent Used for Row Insert:10
Enter values in Extents Pane as follows:
Initial Extents:1024,select Byte option from drop down list
Next Extents:1024,select Byte option from drop down list
Min Extents:1
Max Extents:255
Pct Increase:10
Enter values in Free lists Pane as follows:
Free Lists:10
Free Groups:10
Enter values in Options Pane as follows:
Parallel:2
Caching: select YES from drop down list
Click on Create icon
Cluster is created successfully.
4.Go to Clusters object folder,expand it
Go to trial_one,right click and select Cluster Properties option
Cluster Properties window get opened
In window we can see some fields are display blank in General,Extents,Free Lists Pane but while creating I have given values for that fields
Please refer screenshot(storage_tab.jpg)
