Skip to content

Latest commit

 

History

History
66 lines (47 loc) · 4.1 KB

Oracle Database.md

File metadata and controls

66 lines (47 loc) · 4.1 KB

Database | Oracle

ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c, 13c, 18c, 19c, 21c, 23ai)

Referrences

DBA Guides

Architecture

Oracle / PLSQL: Data Types

Database Limits (Data field types support)

Best practices for implementing data warehouse in Oracle 12c http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-dw-best-practices-for-implem-192694.pdf

Oracle brings the Autonomous Database to JSON | ZDNET

Install

Oracle SQL Developer Release 19.2 - Get Started

Maintenance

Oracle Warehouse Management User's Guide

sql - How to Select Top 100 rows in Oracle? - Stack Overflow Databases and Performance: Top Oracle Monitoring Views & Tables Granting Rights on Stored Procedure to another user of Oracle - Stack Overflow Databases and Performance: Interactive Complex SQL Scripts - A Solution Oracle Database: How-To: Create a New database using DBCA - YouTube

Importing

RMAN> SET DBID 12345;  
RMAN> STARTUP NOMOUNT;  
  
RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";   
RMAN> ALTER DATABASE MOUNT;  
  
RMAN> RESTORE DATABASE;  
RMAN> RECOVER DATABASE;  
RMAN> ALTER DATABASE OPEN RESETLOGS;

--- Restoring a database
set NLS_LANG=AMERICAN_AMERICA.EE8MSWIN1250  
imp file=ES_20130429_093744.dmp fromuser=aplpop touser=aplpopvl log=imp_in.log  
pause

Audit

Book Review: Security, Audit and Control Features: Oracle Database Auditing Oracle Database

Index

Oracle Bitmap Index | Guide to Oracle Bitmap Index | Query Examples