初次安装oracle数据库11g快捷版后如何新建数据库? [英] How to create a new database after initally installing oracle database 11g Express Edition?

问题描述

我已经在我的电脑上安装了 Oracle Database 11g Express Edition(Windows 7)我也安装了 Oracle SQL Developer.

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well.

我想先创建一个简单的数据库，可能是一两个表，然后使用 Oracle SQL Developer 插入数据并进行查询.

I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert data and query it.

当我打开 Oracle SQL Developer 时，它要求我创建一个新连接，因此它假定已经创建了一个数据库.

When I open Oracle SQL Developer, it asks me to create a new connection, therefore it assumes that a database has already been created.

所以我的问题是，如何在 Oracle 11g 中创建初始数据库?

So my question is, how do I create an initial database in Oracle 11g?

推荐答案

此链接:CreatingOracle 11g 第 2 版中的示例数据库是创建示例数据库的一个很好的例子.

This link: Creating the Sample Database in Oracle 11g Release 2 is a good example of creating a sample database.

此链接:Oracle 11g 新手指南如果您在创建数据库时遇到一些常见问题，数据库常见问题应该会对您有所帮助.

This link: Newbie Guide to Oracle 11g Database Common Problems should help you if you come across some common problems creating your database.

祝你好运！

当您使用 XE 时，您应该已经创建了一个数据库，以使用 SQL*Plus 和 SQL Developer 等进行连接.信息在这里:连接到 Oracle 数据库快捷版并探索它.

As you are using XE, you should have a DB already created, to connect using SQL*Plus and SQL Developer etc. the info is here: Connecting to Oracle Database Express Edition and Exploring It.

提取:

从 SQL Developer 连接到 Oracle Database XE SQL Developer 是一个您可以使用它访问 Oracle 数据库 XE 的客户端程序.和Oracle Database XE 11g 第 2 版 (11.2)，必须使用 SQL Developer版本 3.0.本节假设 SQL Developer 安装在您的系统，并展示如何启动它并连接到 Oracle 数据库捷.如果您的系统上未安装 SQL Developer，请参阅 Oracle数据库 SQL Developer 用户指南中的安装说明.

Connecting to Oracle Database XE from SQL Developer SQL Developer is a client program with which you can access Oracle Database XE. With Oracle Database XE 11g Release 2 (11.2), you must use SQL Developer version 3.0. This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle Database XE. If SQL Developer is not installed on your system, see Oracle Database SQL Developer User's Guide for installation instructions.

注意:

对于以下过程:第一次启动 SQL Developer在您的系统上，您必须在步骤 1 中提供 java.exe 的完整路径.

For the following procedure: The first time you start SQL Developer on your system, you must provide the full path to java.exe in step 1.

对于第 4 步，您需要用户名和密码.

For step 4, you need a user name and password.

对于第 6 步，您需要一个主机名和端口.

For step 6, you need a host name and port.

从 SQL Developer 连接到 Oracle Database XE:

To connect to Oracle Database XE from SQL Developer:

启动 SQL Developer.

Start SQL Developer.

有关说明，请参阅 Oracle 数据库 SQL 开发人员用户指南.

For instructions, see Oracle Database SQL Developer User's Guide.

如果这是您第一次在您的计算机上启动 SQL Developer系统，系统会提示您输入 java.exe 的完整路径(对于例如，C:jdk1.5.0injava.exe).在后面输入完整路径提示或浏览到它，然后按 Enter 键.

If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java.exe (for example, C:jdk1.5.0injava.exe). Either type the full path after the prompt or browse to it, and then press the key Enter.

Oracle SQL Developer 窗口打开.

The Oracle SQL Developer window opens.

在窗口的导航框架中，单击连接".

In the navigation frame of the window, click Connections.

出现连接窗格.

在连接"窗格中，单击新建连接"图标.

In the Connections pane, click the icon New Connection.

新建/选择数据库连接窗口打开.

The New/Select Database Connection window opens.

在新建/选择数据库连接"窗口中，键入适当的Connection Name、Username 和 Password 字段中的值.

In the New/Select Database Connection window, type the appropriate values in the fields Connection Name, Username, and Password.

为了安全起见，您键入的密码字符显示为星号.

For security, the password characters that you type appear as asterisks.

密码字段旁边是保存密码复选框.默认情况下，它被取消选择.Oracle 建议接受默认值.

Near the Password field is the check box Save Password. By default, it is deselected. Oracle recommends accepting the default.

在新建/选择数据库连接"窗口中，单击 Oracle 选项卡.

In the New/Select Database Connection window, click the tab Oracle.

出现 Oracle 窗格.

The Oracle pane appears.

在 Oracle 窗格中:

In the Oracle pane:

对于连接类型，接受默认值(基本).

For Connection Type, accept the default (Basic).

对于角色，接受默认值.

For Role, accept the default.

在主机名和端口字段中，接受默认值或键入适当的值.

In the fields Hostname and Port, either accept the defaults or type the appropriate values.

选择选项 SID.

在 SID 字段中，输入接受默认值 (xe).

In the SID field, type accept the default (xe).

在新建/选择数据库连接"窗口中，单击测试"按钮.

In the New/Select Database Connection window, click the button Test.

连接已测试.如果连接成功，状态指示器从空白变为成功.

The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success.

插图成功说明.gif

如果测试成功，请单击连接"按钮.

If the test succeeded, click the button Connect.

新建/选择数据库连接窗口关闭.连接窗格显示您在连接名称中输入其名称的连接步骤 4 中的字段.

The New/Select Database Connection window closes. The Connections pane shows the connection whose name you entered in the Connection Name field in step 4.

您在 SQL Developer 环境中.

You are in the SQL Developer environment.

要退出 SQL Developer，请从文件"菜单中选择退出".

To exit SQL Developer, select Exit from the File menu.

这篇关于初次安装oracle数据库11g快捷版后如何新建数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！