If this is a non-production system, and you wish to quickly rebuild the tables for IM, you may drop the database login/app ID with the associated tables, then recreate the database login/app ID
IM, when it restarts, will check and rebuild or update the database schema for the six (6) IM databases.
Example for Oracle (used in SQL statement or paste in SQL command line window), to start the solution's DB in a "clean state".
(Below example uses a db login ID idmdba001 that will own a database called "idmdba001"
drop user idmdba001 cascade;
create user idmdba001 identified by Password01;
grant connect, resource to idmdba001;
grant create table, create view, create session, create trigger, create sequence to idmdba001;
grant create tablespace, drop tablespace, manage tablespace, unlimited tablespace to idmdba001;
Cheers,