gpt4 book ai didi

java - 如何在oracle XE中创建数据库?

转载 作者:搜寻专家 更新时间:2023-10-31 08:12:32 25 4
gpt4 key购买 nike

在 oracle XE 中,有一个预装的数据库,关于员工和部门等等,但是我想创建一个新的数据库,我知道我可以在命令行中完成,但我检查了数据库主页,我只发现在 GUI 或浏览器中创建表,我需要创建自己的数据库,并创建一个只能访问此数据库而不能访问员工数据库的用户

最佳答案

I think you mean "schema" and not "database". The installer program creates a database named XE, and inside that database is a schema named HR. To create additional schemas you could use any Oracle tool like SQLPlus or Database Control, and all you do is create a new user account (because user=schema). However, what Oracle probably prefers over SQLPlus is that you access the XE "Home Page" on your computer using the shortcut they put on your Win2K desktop, and then click on the Administration link

在这里阅读更多:http://www.dbforums.com/oracle/1605421-creating-new-db-express-edition.html

关于java - 如何在oracle XE中创建数据库?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/10750938/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com