Oracle® Database Express Edition 2 Day DBA 10g Release 2 (10.2) Part Number B25107-01 |
|
|
View PDF |
Oracle Database Express Edition (Oracle Database XE) is a free, smaller-footprint edition of Oracle Database. Oracle Database XE is easy to install and easy to manage.
With Oracle Database XE, you use an intuitive browser-based interface to:
Administer the database
Create tables, views, and other database objects
Import, export, and view table data
Run queries and SQL scripts
Generate reports
Oracle Database XE also includes Oracle Application Express release 2.1, a declarative, graphical development environment for creating database-centric Web applications. In addition to Oracle Application Express release 2.1, you can use all the popular Oracle and third-party languages and tools to develop your Oracle Database XE applications.
Oracle Database XE also includes the following command-line utilities:
SQL Command Line (SQL*Plus), for entering SQL and PL/SQL commands and running scripts
SQL*Loader, for loading data into the database
Data Pump and the Import and Export utilities for data import and export
This section contains the following topics:
Oracle Database Express Edition (Oracle Database XE) has a browser-based user interface for administering the database, running scripts and queries, building Web-based applications, and more. The starting point for this interface is the Database Home Page.
Note:
After installation, the Database Home Page is enabled only on the computer on which you installed Oracle Database XE (the local computer). As an administrator, you can enable the Database Home Page for remote users. See "Enabling Remote HTTP Connection to the Database" for instructions.The large icons on the Database Home Page have the following functions:
Administration—Manage database user accounts, manage memory, storage, and network connections, monitor database activity, and view configuration information.
Object Browser—View, create, modify, browse, and drop database objects. Use the PL/SQL editor to edit and compile packages, procedures, functions, and triggers while taking advantage of error reporting.
SQL—Access the following SQL tools:
SQL Commands—Run SQL commands and anonymous PL/SQL blocks. Run scripts and saved queries.
SQL Scripts—Create, edit, view, run, and delete script files. Upload and download scripts from your local file system.
Query Builder—With little or no SQL knowledge, build SQL queries using a graphical user interface. View formatted query results and save queries.
Utilities—Load and unload data, generate DDL, view object reports, and restore dropped database objects.
Note:
When you log in to the Database Home Page as a user other thanSYSTEM
, another icon named Application Builder becomes available. You use Application Builder to develop Oracle Application Express applications.You can access the Database Home Page from your desktop or by pointing your Web browser to a specific URL. The following sections provide details:
Accessing the Database Home Page with Your Web Browser—Local User
Accessing the Database Home Page with Your Web Browser—Remote User
To access the Database Home Page from the desktop:
Do one of the following:
On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 10g Express Edition, and then select Go to Database Home Page.
On Linux with Gnome: In the Applications menu, point to Oracle Database 10g Express Edition, and then select Go to Database Home Page.
On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 10g Express Edition, and then select Go to Database Home Page.
When the login page appears, log in to the database using a valid database user name and password.
To log in as an administrator, log in with user name SYSTEM
, and supply the password that you specified during installation (Windows platform) or configuration (Linux platform).
Upon successful login, the Database Home Page appears.
To access the Database Home Page with your Web browser from the same computer on which you installed Oracle Database XE:
Point your browser to the following URL:
http://127.0.0.1:port/apex
where port
is the TCP port number for HTTP connection requests. The default value is 8080. You may have changed this value during installation (Windows platform) or configuration (Linux platform).
For example, if you installed Oracle Database XE with the default port number, you would access the Database Home Page at this URL:
http://127.0.0.1:8080/apex
When the login page appears, log in to the database using a valid database user name and password.
To log in as an administrator, log in with user name SYSTEM
, and supply the password that you specified during installation (Windows platform) or configuration (Linux platform).
Upon successful login, the Database Home Page appears.
Note:
Before you can access the Database Home Page from a remote computer, you must enable remote access to the Oracle Database XE graphical user interface. See "Enabling Remote HTTP Connection to the Database" for instructions.To access the Database Home Page with your Web browser on a remote computer:
Point your browser to the following URL:
http://host:port/apex
where:
host
is the host name or IP address of the computer where Oracle Database XE is installed.
port
is the TCP port number for HTTP connection requests. The default value is 8080. You may have changed this value during installation (Windows platform) or configuration (Linux platform).
For example, if you installed Oracle Database XE on a computer with the host name myhost.mydomain.com
, and you installed with the default port number, you would access the Database Home Page at this URL:
http://myhost.mydomain.com:8080/apex
When the login page appears, log in to the database using a valid database user name and password.
To log in as an administrator, log in with user name SYSTEM
, and supply the password that you specified during installation (Windows platform) or configuration (Linux platform).
Upon successful login, the Database Home Page appears.
You can access context-sensitive online Help in the following ways:
For help with the current page in the Oracle Database XE graphical user interface, click the Help icon at the upper right-hand corner of the page.
This opens the Help window. In addition to viewing the Help information specific to the page, you can browse through Help topics by expanding and collapsing the table of contents in the left pane.
A search facility in the Help window enables you to search all online Help topics. To search, click the Find link at the top of the Help window.
For help with an individual data field on the page, position the cursor over the field label. If the field label turns red and the cursor changes to an arrow with a question mark, help is available for that field. Click the field label to view the help in a separate window.
To open the Help window when not using the Oracle Database XE graphical user interface, do one of the following:
On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 10g Express Edition, point to Get Help, and then select Read Online Help.
On Linux with Gnome: In the Applications menu, point to Oracle Database 10g Express Edition, point to Get Help, and then select Read Online Help.
On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 10g Express Edition, point to Get Help, and then select Read Online Help.
This section describes alternative methods for navigating between pages in the Oracle Database XE graphical user interface. It contains the following topics:
See Also:
"Accessing the Database Home Page"You can navigate the Oracle Database XE graphical user interface by clicking the large icons on the Database Home Page and on other navigation pages. When using these icons, you have two options:
Clicking the icon—Click the icon to go to the page indicated by the icon name.
You may have to click a number of these icons, descending one page at a time in the page hierarchy, before you reach your destination page.
Selecting from the icon's menu—Click the down arrow on the right-hand side of the icon to view a menu, and then select an option from the menu or from any of its submenus.
This is a more direct method of reaching some pages.
Breadcrumbs (also called locator links) appear at the top of every page in the Oracle Database XE graphical user interface. Each breadcrumb trail indicates where the current page is in the hierarchy of pages. You can use breadcrumbs to instantly link to the previous page or to any of the pages above the current page in the hierarchy. In the following example, which is taken from the Query Builder page, clicking Home takes you to the Database Home Page: