您如何将示例Oracle HR数据库导入SQL Developer?

问题描述：

我想我现在要解决这个问题.如果可以的话，我会自行回答

I think I'm close to solving this now. i will self-answer if so

我已经坚持了一段时间-我想使用示例Oracle人力资源数据库.我一直在通过这些说明进行研究，但无济于事

I've been stuck on this for a while now - I want to use the sample Oracle Human Resources database. I've been studying through these instructions to no avail.

因此，我已经下载了Oracle Database 11g Express Edition和SQL Developer.我可以使用它并创建一个示例数据库.但是我不知道如何使用人力资源数据库.

So I have downloaded both Oracle Database 11g Express Edition, along with SQL Developer. And I can play with it and create a sample database. But I don't know how to use the HR database.

任何提示，不胜感激.谢谢

any tips appreciated. thanks

答

好消息-我终于明白了.我必须进入SQL命令行，然后放入这些命令(

Good news - I finally figured it out. I had to go into SQL Command Line, and then put in these commands( from this link) :

类型:连接

输入用户名:system

Enter user-name: system

输入密码:

然后，我们需要解锁HR:

Then, we need to unlock the HR :

SQL> ALTER USER hr ACCOUNT UNLOCK;

然后我们为该用户输入密码:

Then we make a password for this user :

SQL> ALTER USER hr IDENTIFIED BY <hr-password>;

因此，在此之后，我可以从SQL Develloper访问它.谢谢

So after this, I could access it from SQL Develloper. thanks

您如何将示例Oracle HR数据库导入SQL Developer?

相关推荐