In this post, you’ll learn more about the Oracle ErrorIMG-00926: tablespace specified during CREATE INDEX is not valid with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
IMG-00926: tablespace specified during CREATE INDEX is not valid
Reason for the Error IMG-00926: tablespace specified during CREATE INDEX is not valid
Cause: A tablespace specified in the parameter string of a CREATE INDEX operation did not exist or the current user did not have sufficient privileges on the tablespace.
How to fix the Error IMG-00926: tablespace specified during CREATE INDEX is not valid ?
You can fix this error in Oracle by following the below steps
Action: Create the tablespace, grant appropriate privileges on the tablespace to the current user, or choose a different tablespace.