We have a web application which manages digital documents,
its main table is named "DOC_ADJUNTO", this table has a column "DOCUMENTO" of type BLOB and some other columns.
Also there is an Oracle Text Index for the BLOB column of the table "DOC_ADJUNTO"; its definition as follow:
CREATE INDEX IDX_DOC_ADJUNTO_DOCUMENTO ON DOC_ADJUNTO (DOCUMENTO) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Sync (on commit)') NOPARALLEL;
Just a week ago, a new table "CMP3$111448" appeared in database.
The table "CMP3$111448" replicates the structure of table "DOC_ADJUNTO" and its Oracle Text Index, so it is spending a lot of space for the tablespace and backups for whole database.
One difference between the two tables is that "DOC_ADJUNTO" table has 136.782 rows, and "CMP3$111448" only has 107.380 rows.
I have the following questions about this fact:
a) Why the table "CMP3$111448" appeared?
b) Can I just drop the table "CMP3$111448" to reclaim back the space? ¿Will not materialize a negative effect?
c) If I drop the table "CMP3$111448", will a similar table appear again? If yes, how can I avoid it happens?
I really would appreciate a little of feedback before I take an action to get back the space.
Regards