I want to remove my Dmu repository but the Menu "Configure DMU Repository" is grayed-out.
Is there any script available to perform this task in command line?
Thanks for any clue you may have.
Do you get any error messages while connecting to the database? Is there any error reported in the Log Pane or in the log files (%APPDATA%\DMU\log\* or $HOME/.dmu/log/*)?
You can drop the repository by running \dmu\dmu\admin\drop_repository.sql but this is not the normal way to do this. The menu item should not be greyed out if you are connected successfully. It would be good to investigate the cause of this issue.
Yes thank you, in-between I found the scripts in dmu\dmu\admin directories and used it. It solved my issue.
But to come back to the use case (if interestig for analysis):
- I launched a conversion on my 18.104.22.168.
- It failed due to TBS size (had CTAS option set for some of my big tables).
- I abort the conversion and had to re-import the backup of my db in my applicative schema.
- Then the menu was grayed-out.
The problem was due to the fact that you restored just the application schema from an import file. As the aborted conversion might have left any table in the database in an inconsistent state, you should have restored the whole database from a physical backup (or flashed it back to a point before the conversion started).
If you encounter a space error that you can correct by adding more storage space, you should let the DMU retry the statement after fixing the problem instead of aborting the conversion. To fix the problem, you can connect with a client tool, like SQL*Plus or SQL Developer, issue the required DDL statements, and disconnect. Then, you can select "Retry" next to the error and click the Continue button.