Oracle Database 12c Quickstart
5/5
()
About this ebook
The essential getting started guide to Oracle Database 12c. This book covers:
* Installation
* Database Fundamentals
* Database Creation
* Tablespaces
* User Accounts and Roles
* Database Schema (tables, indexes, sequences, synonyms, views...)
* RMAN Backups and more!
Michael Elliott
The novel "American Jihad Rising" combines Michael Elliott's love of writing with his intense interest in politics and current events. An award-winning advertising copywriter and commercial broadcast producer, Mr. Elliott spent several years writing movie screenplays via The William Morris Agency. His interest in Islamic-inspired terrorism began when he witnessed the destruction of the World Trade Center Twin Towers from just across the Hudson River in New Jersey. The spark that produced this novel started in 2009 when he became acquainted with military members of the Defense Department's Counter Terrorism Unit headquartered in the Pentagon. The things he learned convinced him the dangers posed by international and domestic terrorism were even greater than he had originally imagined. As he developed the novel's various scenarios, he tested them on a U.S. Army Colonel who had in-depth knowledge of terrorist networks and their plans. He was told his scenarios not only were plausible but likely to unfold in the near future. Mr. Elliott lives in his hometown of Annapolis, MD
Related to Oracle Database 12c Quickstart
Related ebooks
Introduction to Oracle Database Administration Rating: 5 out of 5 stars5/5Concise Oracle Database For People Who Has No Time Rating: 0 out of 5 stars0 ratingsStarting Database Administration: Oracle DBA Rating: 3 out of 5 stars3/5Oracle Data Guard 11gR2 Administration Beginner's Guide Rating: 0 out of 5 stars0 ratingsOracle SQL In 10 Minutes Rating: 5 out of 5 stars5/5Basic DBA Query v.1: Oracle Database Rating: 5 out of 5 stars5/5Oracle Quick Guides: Part 1 - Oracle Basics: Database and Tools Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 1 Rating: 5 out of 5 stars5/5Oracle Quick Guides: Part 3 - Coding in Oracle: SQL and PL/SQL Rating: 0 out of 5 stars0 ratingsOracle Database 12c Backup and Recovery Survival Guide Rating: 5 out of 5 stars5/5Oracle Quick Guides: Part 2 - Oracle Database Design Rating: 0 out of 5 stars0 ratingsSQL Server 2014 Development Essentials Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5ORACLE PL/SQL Interview Questions You'll Most Likely Be Asked Rating: 5 out of 5 stars5/5Oracle Business Intelligence Enterprise Edition 12c - Second Edition Rating: 0 out of 5 stars0 ratingsDatabase Management for Business Leaders: Building and Using Data Solutions That Work for You Rating: 0 out of 5 stars0 ratingsOracle Quick Guides: Part 4 - Oracle Administration: Security and Privilege Rating: 0 out of 5 stars0 ratingsAccounting Database Design Rating: 5 out of 5 stars5/5Oracle Information Integration, Migration, and Consolidation Rating: 0 out of 5 stars0 ratingsLearn Data Warehousing in 24 Hours Rating: 0 out of 5 stars0 ratingsSQL Server Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsPostgreSQL for Data Architects Rating: 0 out of 5 stars0 ratingsInstant PostgreSQL Backup and Restore How-to Rating: 0 out of 5 stars0 ratingsOracle Database 11g - Underground Advice for Database Administrators: Beyond the basics Rating: 0 out of 5 stars0 ratingsOracle GoldenGate 11g Implementer's guide Rating: 5 out of 5 stars5/5DBA's Guide to NoSQL Rating: 5 out of 5 stars5/5Learn MongoDB in 24 Hours Rating: 5 out of 5 stars5/5SQL Rating: 0 out of 5 stars0 ratings
Databases For You
Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsBlockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Mastering Blockchain Rating: 5 out of 5 stars5/5Learn Git in a Month of Lunches Rating: 0 out of 5 stars0 ratingsCompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratingsHadoop Essentials Rating: 5 out of 5 stars5/5Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5Practical Data Analysis Rating: 4 out of 5 stars4/5Managing Data Using Excel Rating: 5 out of 5 stars5/5COMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsBlockchain For Dummies Rating: 5 out of 5 stars5/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsNode.js Design Patterns - Second Edition Rating: 4 out of 5 stars4/5Star Schema The Complete Reference Rating: 5 out of 5 stars5/5Dark Data: Why What You Don’t Know Matters Rating: 3 out of 5 stars3/5Data Analysis with R Rating: 5 out of 5 stars5/5Learn SQL Server Administration in a Month of Lunches Rating: 3 out of 5 stars3/5Artificial Intelligence Basics: A Non-Technical Introduction Rating: 5 out of 5 stars5/5Tableau Cookbook – Recipes for Data Visualization Rating: 0 out of 5 stars0 ratingsSimply SQL: The Fun and Easy Way to Learn Best-Practice SQL Rating: 4 out of 5 stars4/5Excel 2021 Rating: 4 out of 5 stars4/5Entity Framework Core in Action Rating: 0 out of 5 stars0 ratingsPostgreSQL Administration Essentials Rating: 0 out of 5 stars0 ratingsVisualizing Graph Data Rating: 0 out of 5 stars0 ratings
Reviews for Oracle Database 12c Quickstart
5 ratings0 reviews
Book preview
Oracle Database 12c Quickstart - Michael Elliott
Oracle 12c Database Quickstart
-
by Michael Elliott
© Michael Elliott 2015,2016
Edition 2
All rights reserved. You are welcome to redistribute this book in its original form.
The author acknowledges the trademarked status and trademark owners of various products referenced in this work.
The author acknowledges the trademarked status and trademark owners of various products referenced in this work, which have been used without permission. The publication/use of these trademarks is not authorized, associated with, or sponsored by the trademark owners.
Table of Contents
Preface
Introduction
Installation
Database Creation
Database Start|Stop
Tablespaces
Users and Roles
Schema
Tables
Indexes
Constraints
Database Links
Directory Objects
Sequences
Synonyms
Views
Backups
Restore Scenarios
Appendix - RMAN Maintenance
Preface
I am an Oracle Certified Professional (OCP), MCSE, ITIL certified, published book author, application developer and have been working as a database administrator for over 20 years. My other interests include various programming languages and drums. I also host oracledba.help.
Oracle is hard enough! The main purpose of this material is to enable you to perform common DBA tasks as quickly and accurately as possible. I am crazily dedicated to keep optimizing these topics to be as concise as possible. I’ll leave documenting every option of every feature to the 800+ page manuals.
In all of the examples please change as nesessary to match your environment.
Thanks for choosing this book!
Disclaimer
This book is presented solely for educational and entertainment purposes. The author and publisher are not offering it as legal, accounting, or other professional services advice. While best efforts have been used in preparing this book, the author and publisher make no representations or warranties of any kind and assume no liabilities of any kind with respect to the accuracy or completeness of the contents and specifically disclaim any implied warranties of merchantability or fitness of use for a particular purpose. Neither the author nor the publisher shall be held liable or responsible to any person or entity with respect to any loss or incidental or consequential damages caused, or alleged to have been caused, directly or indirectly, by the information or programs contained herein. No warranty may be created or extended by sales representatives or written sales materials. Every company is different and the advice and strategies contained herein may not be suitable for your situation.
Introduction
Overview
If you are going to be an effective DBA there is no escaping knowing the Oracle database fundamentals. If you are new to Oracle perhaps scan it then revisit it until it is in your DNA. This is for you veteran DBAs too! Why? Because Oracle keeps changing. Many Oracle fundamentals stay the same. Many do not. You can be more effective managing an Oracle database based on how it actually works rather than how you believe it does. In establishing the foundation here I have been able to keep the presentation of most Oracle tasks found in the other sections as concise as possible.
Database Storage
An Oracle database is made up of a set of files containing data and metadata. Information is stored persistently in these