Installing sample schemas in oracle 10g

Enter temp as the temporary tablespace for HR. To verify that the schema was created, use the following command:. For example, If you want a Resetting Sample Schemas.

Uninstalling Sample Schemas. The mksample script expects 11 parameters. Specify a temporary and a default tablespace, and make sure to end the name of the log file directory with a trailing slash. If an error occurs, verify the settings with your database administrator, click B ack to make any changes necessary, and then retest the connection. Click F inish. The connection now appears below the Database connection node in the Connection Navigator.

Once you have created a connection to one of the sample schemas, you can examine the schemas from JDeveloper. Expand Database , then the node for the connection you have just made, then the node for the hr or OE schema. Move your mouse over this icon to hide all screenshots. Creating and Populating the Sample Schema Tables. Creating a Database Connection. Have access to an Oracle8 i , Oracle9 i , or Oracle 10 g database, and know the passwords for the system and sys users.

Installing the Oracle8 i Sample Schemas. Dropping the Oracle8 i Sample Schemas. Name the application workspace Samples , then click OK. Choose V iew Co n nection Navigator. In the C o nnection Name field type a name for the connection. On the Authentication page: In the U sername and P assword fields, type the user name and password.

If you choose not to install the sample schemas at that time, you can add them later by following the instructions in section "Manually Installing Sample Schemas". At the end of the installation process, a dialog box displays the accounts that have been created and their lock status. By default, all sample schemas are locked and their passwords are expired.

Before you can use a locked account, you must unlock it and reset its password. You can unlock the accounts at this point in the installation process. For example:. The sample schemas available to you depend on the edition of Oracle Database that you have installed and its configuration. Refer to the following table:. If you decide not to install the sample schemas at the time of your initial database installation using DBCA, then you can also create the sample schemas manually by running SQL scripts.

Various dependencies have been established among the schemas. Create schema OE. Some HR tables are visible to user OE with the use of private synonyms. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Related 1.