Menu

Reference - Remove a database project

jan ripke

Reference - Remove a database project from the database.

To remove a database project from the database, the drop plugin is used.
The following parameters are expected:

-s, the oracle sid of the database to remove the project from.

I assume that that database project ''my_project_db'' is used.
Change into that directory.

> cd my_project_db

On your command line, perform the following:

> noora.py drop -s=orcl

The command line will print out various actions, the following is shown.

dropping scheme 'apps' in database 'orcl' using environment 'dev'
apps:/plugins/static/drop/scm/drop_schemas.sql
apps:/plugins/static/drop/vw/drop_views.sql
apps:/plugins/static/drop/syn/drop_synonyms.sql
apps:/plugins/static/drop/trg/drop_triggers.sql
apps:/plugins/static/drop/typ/drop_types.sql
apps:/plugins/static/drop/tab/drop_tables.sql
apps:/plugins/static/drop/prc/drop_procedures.sql
apps:/plugins/static/drop/fct/drop_functions.sql
apps:/plugins/static/drop/pkg/drop_packages.sql
apps:/plugins/static/drop/jar/drop_jars.sql
apps:/plugins/static/drop/seq/drop_sequences.sql
apps:/plugins/static/drop/idx/drop_indexes.sql
apps:/plugins/static/drop/dbl/drop_database_links.sql
scheme 'apps' dropped.

What did I just do?

You executed the NoOra plugin drop. The drop plugin removed the project from the database.


Related

Wiki: Plugins - Oracle - Drop
Wiki: Reference Guide

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.