Hi everybody, i'm back.
Today i will talk about a specific process, that i´m been working for, that is a "fast cleaning the contents in a schema".
So, i will explain and show the main script to clear out all objects from dba_segments from user.
You could have two situations to use this procedure:
a) to an inport data&metada to an existente user with no objects.
b) to droping a fast user.
This metoth is fastest than a "Drop user cascade".
The explanation is simple:
You just need understand the relational link bettwen the objects, and then cleanup from the bottom of priroraty, or the bottom of pyramid.
See you soon with the example.
