In this post, you’ll learn more about the Oracle ErrorORA-37001: You have one or more attached but unupdated analytic workspaces. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-37001: You have one or more attached but unupdated analytic workspaces.
Reason for the Error ORA-37001: You have one or more attached but unupdated analytic workspaces.
The user has attempted to shut down OLAP, but they have active analytic workspaces whose changes have not been saved.
How to fix the Error ORA-37001: You have one or more attached but unupdated analytic workspaces. ?
You can fix this error in Oracle by following the below steps
Either issue the update command to update the AWs, or pass TRUE as the force parameter to dbms_aw.shutdown()