EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Sample Database for Oracle

By Priya PedamkarPriya Pedamkar

Secondary Sidebar
Oracle Tutorial
  • Advanced
    • Timestamp to Date in Oracle
    • Oracle Golden Gate
    • Oracle Virtual Machine
    • Oracle Describe Table
    • Oracle Clauses
    • Oracle Having Clause
    • Oracle?Primavera
    • Oracle FOREIGN Key
    • PIVOT in Oracle
    • Oracle Alter Table
    • Oracle Queries
    • Oracle Views
    • Oracle Window Functions
    • Oracle String Functions
    • Oracle Date Functions
    • Oracle Analytic Functions
    • Oracle Aggregate Functions
    • Select in Oracle
    • INSERT in Oracle
    • DISTINCT in Oracle
    • Function in Oracle
    • Oracle GROUP_CONCAT
    • Oracle INSTR()
    • Oracle CONVERT
    • Oracle LENGTH()
    • Oracle EXISTS
    • Oracle REPLACE()
    • Oracle MERGE
    • Oracle LEAD()
    • Oracle EXTRACT()
    • Oracle LISTAGG()
    • Oracle SYS_CONTEXT()
    • Oracle COALESCE
    • Oracle NVL()
    • Oracle SYSDATE()
    • Oracle?Date Format
    • Oracle SYS_GUID()
    • Oracle WILDCARDS
    • Oracle Synonyms
    • Oracle Subquery
    • BETWEEN in Oracle
    • FETCH in Oracle
    • Oracle Index
    • Oracle Function-based Index
    • Oracle UNIQUE Index
    • Oracle Bitmap Index
    • Oracle Column
    • Oracle Triggers
    • Oracle Procedures
    • Sample Database for Oracle
    • Oracle LIKE Operator
    • ORDER BY in Oracle
    • Oracle ORDER BY DESC
    • GROUP BY in Oracle
    • Oracle GROUP BY HAVING
    • Oracle Aliases
    • Table in Oracle
    • Oracle Temporary Table
    • Oracle? Table Partition
    • Oracle rename table
    • Oracle CTE
    • Cursor in Oracle
    • Oracle LOCK TABLE
    • Oracle Tablespace
    • Oracle CARDINALITY
    • Oracle REGEXP
    • Oracle REGEXP_REPLACE
    • Oracle to_date
    • JSON in Oracle
    • Oracle COMMIT
    • Oracle GRANT
    • Oracle MD5
    • Oracle ROLLBACK
    • Oracle Users
    • Oracle TIMESTAMP
    • IF THEN ELSE in Oracle
    • Oracle While Loop
    • Oracle Clone Database
    • Oracle Backup Database
    • Oracle? XML
    • Oracle XMLAGG
    • Oracle XMLTABLE
    • Oracle Performance Tuning
    • Oracle B Tree Index
    • Oracle fusion
    • Oracle ebs
    • Oracle GRC
    • Oracle ERP
    • Oracle ASM
    • Oracle Cloud
    • Oracle HCM Cloud
    • Oracle Integration Cloud
    • Oracle Jinitiator
    • Oracle pathfinder
    • Oracle VirtualBox
    • Oracle Weblogic Server
    • Oracle decode
    • Oracle Exadata
    • Oracle ZFS
    • Oracle? utilities
    • JDBC Driver for Oracle
    • Oracle? DBA Versions
    • Oracle DBA Salary
  • Basic
    • Oracle Marketing Cloud
    • What is Oracle?
    • Career in Oracle
    • How to Install Oracle
    • Oracle Versions
    • What Is Oracle Database
    • Oracle Data Warehousing
    • Oracle Warehouse Builder
    • Career In Oracle Database Administrator
    • Career In Oracle DBA
    • What is Oracle RAC
    • Oracle DBA
    • Oracle? Vanderbilt
    • What is RMAN Oracle
    • Oracle Database Administration
    • Oracle Operators
    • Oracle Constraints
    • Oracle number
    • Oracle Data Types
    • Oracle UNIQUE Constraint
    • Oracle Check Constraint
  • Joins
    • Joins in Oracle
    • Inner Join in Oracle
    • Oracle Cross Join
    • Left Join in Oracle
    • OUTER Join in Oracle
    • Oracle Full Outer Join
    • Natural Join in Oracle
    • Oracle Self Join
    • Oracle hash join
    • Oracle? Update with Join
  • Oracle SET Operators
    • UNION in Oracle
    • Oracle UNION ALL
    • INTERSECT in Oracle
    • MINUS in Oracle
  • Interview Questions
    • Oracle Interview Questions
    • Oracle Apps Interview Questions
    • Oracle Apps Technical Interview Questions
    • Oracle Database Interview Questions
    • Oracle Forms Interview Questions
    • Oracle PL/SQL Interview Questions
    • Oracle RAC Interview Questions
    • Oracle SOA Interview Questions

Related Courses

Oracle Course Training

Oracle DBA Certification Course

MongoDB Certification Training

Home Data Science Data Science Tutorials Oracle Tutorial Sample Database for Oracle

Sample Database for Oracle

Introduction to Sample Database for Oracle

This article will give you an outline of Oracle Database and help you step by step to create a sample database using Oracle database server. Oracle database is a multi-model database management system created and distributed by Oracle Corporation. A database server is supposed to manage enormous amounts of data in a concurrent multi-user environment. In such a scenario, a DBMS server is required to be providing high performance, authorized access and failure recovery features.

Oracle database is designed for enterprise grid computing and used for online transaction processing & data warehousing. The latest database versions from Oracle e.g. Oracle Database 19C are now available on cloud or in a hybrid cloud environment.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

The main features of an Oracle database include:

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (85,938 ratings)
  • Portability
  • Application Clusters
  • Enterprise Manager
  • SQL
  • Automatic Storage Management
  • Backup and Failure of recovery

How to Create Sample Database?

We can create a database during the Oracle database software installation. However, we can also create a database after the installation. Before moving to database creation, it is a prerequisite to install the software.

We can create a database in two ways:

  • With Database Configuration Assistant (DBCA), a graphical tool.
  • Create a Database SQL statement.

However, the first way is strongly recommended by Oracle as it is a more automated and non-hectic approach. So, we will create one by using DBCA with following steps:

Step 1: This is the first step to create a database. First of all, launch the DBCA tool from Start >> Programs. Here, we get a list of options to create a new database, configure an existing database, delete a database, and manage template and pluggable databases. Since we are creating a new one, so we need to select ‘Create a new Database’ (selected by default).

sample database for oracle 1

Step 2: Choose the ‘Advanced Configuration’ and click on ‘Next’.

sample database for oracle 2

Step 3: Now, we need to select the database type and template. Select ‘Custom Database’ for now. We can check the details of other types by clicking on ‘details’.

Following are the all template options available:

  • Data Warehouse
  • General purpose
  • Custom Database

sample database for oracle 3

Step 4: Provide ‘Global Database Name’ and ‘SID’ name. Here, you can choose to create a database container with single or multiple PDBs (pluggable databases).

sample database for oracle 4

Step 5: Select the location to store the files. With the first option, the storage type and location for the database will be picked from the selected template. However, you can also choose your preferred location by selecting the other option.

sample database for oracle 5

Step 6: Choose the storage location for backup and recovery files. Fast Recovery Area is a disk space that can contain backup files, log files and control files. It is always recommended to configure this location.

sample database for oracle 6

Step 7: Next, we need to Memory Management for SGA and PGA. For this, we should select the ‘Use Automatic Memory Management’. It will assign one larger chunk and Oracle will manage the memory.

sample database for oracle 7

Step 8: Specify the manager for the database. We get two options i.e. Enterprise Manager Database Express and Enterprise Manager Cloud Control. As we are creating the database in our local system, we should choose the default ‘Configure EM database Express’ option only.

sample database for oracle 8

Step 9: Set user credentials for the database. We can set different or same passwords for SYS, SYSTEM and PDB_ADMIN users. We are keeping the same credentials for all accounts.

Image 9

Step 10: Select ‘Create Database’ as the creation option and click ‘Next’.

Image 10

Step 11: We can see the summary of the database in the ‘Summary’ section. Click ‘Next’ to proceed. Now, the database creation is in progress. Breathe, it may take some time to finish.

Image 11

Step 12: Once it is finished, you can close the DBCA window, the database will be created in the system. We can check the status of the database by running these commands in command prompt or SQLPLUS.

CONNECT SYS as SYSDBA – to connect to the database server.

SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE

command prompt - SQLPLUS

As we can check, our database is active and ready to use. Now, we can populate our database with tables and data using SQL commands.

How does Oracle Database Work?

In an Oracle Database, there are two main components i.e. database and instance. The collection of memory and processes which contributes to the running installation is called as instance whereas a collection of files that store data is called a database.

That’s how the architecture of a database server looks like:

Database Server

Now let’s try to understand how Oracle stores data. An Oracle database storage has two storage structures i.e. Physical Storage Structure and Logical Storage Structure.

1. Physical Structure

The Physical structure includes the files in which data reside. Whenever we create a database, a bunch of Data files, Control files, redo log files, Backup files Network files and parameter files is generated.

2. Logical Structure

Oracle uses a logical structure to control disk space usage. Following are the elements of the logical storage structure of an Oracle database:

  • Data Blocks – Oracle database stores data in blocks. A block refers to a number of bytes on the disk. Data blocks are also known as logical or Oracle blocks or pages.
  • Extent – It refers to a number of logically adjacent blocks used to store particular information.
  • Segments – A segment consists of extents allocated to store database object like a table or an index.
  • Tablespaces – A database is comprised of logical storage units known as tablespaces. A tablespace acts as a container for a segment. Each tablespace contains at least one data file.

Logical Structure

Conclusion

In this article, we have learned about the Oracle database and its working architecture. It would have also helped you to know how to create one using Oracle DBCA which is Oracle recommended way.

Recommended Articles

This is a guide to Sample Database for Oracle. Here we discuss step by step instructions on how to create a sample database in oracle. You may also have a look at the following articles to learn more –

  1. What is Design Pattern in C#?
  2. Template in Java
  3. What is SSRS?
  4. What is SQL Developer?
  5. Database Parallelism | Top 4 Types of Database Parallelism
Popular Course in this category
Oracle Training (14 Courses, 8+ Projects)
  14 Online Courses |  8 Hands-on Projects |  120+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Oracle DBA Database Management System Training (2 Courses)4.9
All in One Financial Analyst Bundle- 250+ Courses, 40+ Projects4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Special Offer - Oracle Training (14 Courses, 8+ Projects) Learn More