segunda-feira, 28 de julho de 2014

Fast cleaning/drop schema

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.




Sem comentários:

Enviar um comentário