在 Oracle SQL developer 中使用 Data Modeler(查看关系图)
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2287239/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
using Data Modeler (view relational diagram) in Oracle SQL developer
提问by Stan
when trying to view 'Reports > Data Modeler Reports > Design Contents > Relational Model > Relational Designs' in Oracle SQL developer. It gives "Data Modeler reporting repository required." Can anyone see what's wrong with it? Thanks a lot!
尝试在 Oracle SQL 开发人员中查看“报告 > 数据建模器报告 > 设计内容 > 关系模型 > 关系设计”时。它提供了“所需的数据建模器报告存储库”。任何人都可以看到它有什么问题吗?非常感谢!
回答by Tony Andrews
You need to create a reporting repository schema like this:
您需要像这样创建一个报告存储库架构:
SQL> create user DM_REPORT_REPOS identified by DM_REPORT_REPOS;
User created.
SQL> grant connect, resource to DM_REPORT_REPOS;
Grant succeeded.
Then in SQL Developer Data Modeller you can open the model you want to report on and export it to this repository via File/Export/To Reporting Schema. You will need to create a new Connection for the schema you just created.
然后在 SQL Developer Data Modeller 中,您可以打开要报告的模型,并通过 File/Export/To Reporting Schema 将其导出到此存储库。您需要为刚刚创建的架构创建一个新的连接。
Then in SQL Developer you can also create a new Connection for the repository and select this to run the reports.
然后在 SQL Developer 中,您还可以为存储库创建一个新的连接并选择它来运行报告。