![oracle database express edition 11g oracle database express edition 11g](https://docs.oracle.com/cd/E17781_01/install.112/e18803/img/welcome1.gif)
For example, on Windows, click Start, then Programs (or All Programs), then Oracle Database 11g Express Edition, and then Run SQL Command Line.Ĭreate the user. Follow these steps, using the command line:ĭisplay the SQL command prompt window. A database user is a type of database object: a user is associated with a database schema, you connect to the database as a database user, and the database user is the owner of any database objects (tables and so on) that you create in the schema associated with the user.įor example, to create a database user named chris. You should create at least one database user that you will use to create database objects.
#Oracle database express edition 11g password#
Password: Enter the password that was specified when Oracle Database XE was installed. Username: Enter system for the user name. If you are prompted for login information, specify: The Oracle Database XE home page appears:ĭescription of the illustration gs_admin_consl.jpgįor detailed information about these database-level operations, see Oracle Database Express Edition 2 Day DBA.Ĭlick the button or tab for any category you are interested in (for example, Storage). On Linux, click the Application menu (on Gnome) or the K menu (on KDE), then point to Oracle Database 11g Express Edition, and then Get Started. On Windows, from the Start menu, select Programs (or All Programs), then Oracle Database 11g Express Edition, and then Get Started. To access the database home page, follow these steps: Getting started with Oracle Application Express
![oracle database express edition 11g oracle database express edition 11g](https://venzi.files.wordpress.com/2019/08/oracle-database-18c-xe-sqldeveloper-connection-success.png)
Viewing database initialization parameters
![oracle database express edition 11g oracle database express edition 11g](https://static.packt-cdn.com/products/9781849686747/graphics/6747_04_01.jpg)
The Database home page is a web browser-based interface for performing various database administration operations, including the following:
![oracle database express edition 11g oracle database express edition 11g](https://venzi.files.wordpress.com/2019/08/oracle-database-18c-xe-installer-screen.png)
(If the database is not currently stopped, an informational message is displayed that the database is already started.) However, to reduce the overall performance load on the system, you can manually stop the database, and then manually restart it later. By default, the database is started for you after installation and every time your computer is restarted. Start Database: Starts Oracle Database XE if it is currently stopped. To get help, you can enter the command help at the SQL prompt after you have connected to the database. Where username is the user name, such as system or another user account name, and password is the password that was assigned when Oracle Database XE was installed or when that user was created. To connect to the database, issue the connect command in the following format at the SQL prompt: Run SQL Command Line: Starts the SQL Command Line utility for Oracle Database XE. For more information on restoring a database, see Oracle Database Express Edition 2 Day DBA. Restore Database: Shuts down and then restores the database to the most recent backup. For more information on backups, see Oracle Database Express Edition 2 Day DBA. In ARCHIVELOG mode, performs an online backup of the database. Register For Online Forum: Allows you to register for the Oracle Database XE online forum.īackup Database: In NOARCHIVELOG mode (the default), shuts down the database, backs it up, and then restarts it. Read Documentation: Displays the Oracle Database XE documentation library on the Internet. Go To Online Forum: Displays the online forum for discussions about Oracle Database XE. Get Help: Displays the following selections: On Linux, click the Application menu (on Gnome) or the K menu (on KDE), then point to Oracle Database 11g Express Edition. On Windows, from the Start menu, select Programs (or All Programs), then Oracle Database 11g Express Edition. To access the major features of Oracle Database XE, use the system menu as follows to get to the available specific commands: