How to create/rebuild indexes for tables created by other users for SYSADM? (DBMR2372)
To create/rebuild indexes for tables created by other users, SYSADM should add the table owner’s name before the table name rather than the index name.
For example, user staff creates table test_table, and then SYSADM can use the following commands to create/rebuild index test_index for table test_table.
dmSQL> create index test_index on staff.test_table(c2);
dmSQL> rebuild index test_index for staff.test_table;
Version: DBMaker4.x/5.x
Product: Normal/Bundle
Platform: Windows/Linux