How to Create an Application Schema

You can create an application schema to store your Oracle database tables. In this lesson, I will show you how you can accomplish this task.

To learn how to create an application schema, follow these steps:

  1. You'll need to download and install Oracle 12c. The instructions for the setup can be found in How to use sample schemas. Follow steps 1 through 6 before proceeding to the next step.
  2. You'll need to connect as SYS. Type in the following statement and press Enter:
    Connect as sys
    Type in the password for SYS and then press Enter.
  3. Next you will create a user name as the owner of the application schema. Type in the following SQL statement and press Enter:
    Employee select
    The user has an unlimited quota on the users tablespace. The tables created by this user will be stored on the users tablespace.
  4. Grant the necessary privileges to the user so that the user can connect to Oracle and create one or more tables:
    Grant privileges to the user
  5. Connect as the user. When prompted provide the password:
    Connect as user
  6. Create a simple table:
    Create a simple table
  7. Show the tables in your schema:
    Show tables in schema
    You have created an application schema that contains one table.
Author: Stephen Withrow

Stephen has over 30 years of experience in training, development, and consulting in a variety of technology areas including Python, Java, C, C++, XML, JavaScript, Tomcat, JBoss, Oracle, and DB2. His background includes design and implementation of business solutions on client/server, Web, and enterprise platforms. Stephen has a degree in Computer Science and Physics from Florida State University.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.