Schema

[Cristiano Gomes]

Environment information:
* version of Oracle: 9i
* Operating system: Linux

Good afternoon,

I have a Base with multiple schemas inside, I will run a cleaning to release disk space, what is the best way to make the deletion of schemas that are no longer used, releasing disk space and plucking all the objects tied to that schama?

I do this by the bank commands, type Database drop ... or do I need to delete any file via so?

Thank you

[Dulima-SP]

I am not the most indicated person
Masi think this works

Select all

DROP DATABASE;

General clean
Control File, Datafile. .

[Cristiano Gomes]

Sorry if I did not know how to express myself right. What I have to do is delete some schemas and not the entire database. I know if I connect with the sys and run drop user <nome_usuario> cascade I delete the user, now the question is, doing this I release disk space and the objects tied to that schama?

Thank you

[Dulima-SP]

Logica Mind SIM ....

more this question and advanced ...

While the DBAs do not appear does a test ....
Creates a user a table ...

makes a PL block that inserts data ...

Dos DROP ..

Masi I think it releases yes ....

[ruevers]

Drop the user with Cascade ...

The space on the tablespace is already released, but to ensure I always give a coalescence .... like this:

Select all

alter tablespace <nome da tablespace> coalesce;

[Cristiano Gomes]

Thanks for the info!

Sorry for my inexperience, but this CoalEase command does exactly what? And should it always be run after the user drop?

Thank you

[ruevers]

Explaining in a more practical way, it would be kind .... clean the windows lycheira ...

[Cristiano Gomes]

OK thank you.