Items in recyclebin after data pump export
Hi,
I'm looking at the recyclebin of an 11.2.0.3.0 database which has a daily data pump export that starts at 1930 and finishes at around 2000-ish. One of the things I've spotted is a series of items that show up in the recyclebin every day.
These items are:
| OWNER | ORIGINAL_NAME | OPERATION | TYPE | CREATETIME | DROPTIME |
|---|---|---|---|---|---|
| BLAH_USER | SYS_LOB0000229413C00005$$ | DROP | LOB | 2015-01-14:19:30:15 | 2015-01-14:19:59:06 |
| BLAH_USER | SYS_IL0000229413C00005$$ | DROP | LOB INDEX | 2015-01-14:19:30:15 | 2015-01-14:19:59:06 |
| BLAH_USER | SCHEDULER$_PROGRAM_ARG | DROP | TABLE | 2015-01-14:19:30:15 | 2015-01-14:19:59:06 |
It's easy enough to clear these out and I could incorporate a "purge recyclebin" into the shell script that runs the export, but is there anything I can do to prevent them from appearing in the first place? It feels like Data Pump should be doing a "DROP TABLE xxxx PURGE;" and it isn't.
1