Please Note:

Create and drop domain index

Step

To create a domain index for Oracle database, run the following command:

./pdbctl domainindex -a <database_alias> -t <table_name> -c <column_name> -o c -x <domain_index_name> -n <tablespace_name>

Flag	Data Type	Description
-c	string	Column name on which the domain index will be created or dropped.
-o	string	Option to create or delete domain index. Use c to create and d to drop domain index.
-a	string	Database alias associated with the database user.
-x	string	Domain index name. This flag is valid only for creation of domain index.
-h		Flag to view help for the `domainindex` command.
-t	string	Table name that contains the columns on which the domain index will be created or dropped.
-n	string	Table space name (e.g SYSAUX). It is valid only for creation of domain index.
-- verbose		Print verbose logs.

To create a domain index on column CITY of table CUSTOMERS for the alias demo, run the following command:

./pdbctl domainindex -a demo -t CUSTOMERS -c CITY -o c -x CITY -n USERS

Output

Job ID: 154
Processing...
Job Id 154 | Status : success

To drop a domain index on column CITY of table CUSTOMERS for the alias demo, run the following command:

./pdbctl domainindex -a demo -t CUSTOMERS -c CITY -o d

Output

Job ID: 155
Processing...
Job Id 155 | Status : success