Creating oracle database is an prime responsibilities of an Oracle DBA . We can create oracle database in different methods as follows. Creating database with Database Configuration Assistant(DBCA) Creating database manually In this article , we will create database using Oracle database configuration Assistant (DBCA) utility. Database Configuration Assistant (DBCA) is a Java-base,GUI based , [...]
Published by Paresh Sarma //
Continued from Oracle database data types-I 2. Numeric Data types in oracle Numeric data type in oracle is used to store positive and negative fixed and floating point numbers,zero,infinity, and a special value not a Number. 2.1. NUMBER [(precision [,scale])] – stores positive numbers,negative numbers and zero.Precision is the total number of digits and defaults [...]
Published by Paresh Sarma //
Oracle user management and security is an important Role of an Oracle DBA. In this article I will explain the how database user created and managed for optimal database security. Creating and managing database user A database user can be created using CREATE USER DDL command.Along with CREATE USER DDL statement, an Oracle DBA can [...]
Published by Paresh Sarma //
As being a DBA ,you must concern for database security and always apply to principle of least privilege for granting any privileges and roles to a database user. Principle of least privileges Oracle DBA, should grant minimum privileges to user as much needed to perform their job Oracle DBA , should review the privileges and [...]
Published by Paresh Sarma //
Database table stores business data. When we create table we have to give proper table name as well as specify the column names and data types. Before going to creating table and define columns , we have to follow the following requirements. name must start with a letter no longer than 30 characters must only [...]
Published by Paresh Sarma //
Each column value and constant in a SQL statement has specific data types, which is associated with a specific storage format, constraints, and a valid range of values. When we create a table or other database objects, we have to specify a data types for each columns as per the value to be stored. Oracle [...]
Published by Paresh Sarma //
Oracle database provides the ability to create different types of objects to efficiently manage an information. Following is some commonly used lists of Oracle database objects. Tables Views Indexes Clusters Synonyms Sequences Procedures Functions Packages Triggers Oracle database objects are groups together by a database user, which is commonly called as database Schema. Data dictionary [...]
Published by Paresh Sarma //
Granting privileges are an impact on the security of the database. Oracle DBA should take extra care on granting privileges , specially on system privileges. As being an Oracle DBA , you should review the privileges granted to a database user in regular basis and if noticed that any unnecessary role or privileges are granted [...]
Published by Paresh Sarma //
System Privileges are privileges that are not relate to a specific object or schema. System privileges in Oracle are categorized at the following sections as per their use as follows. 2.1. Database related System Privileges ALTER DATABASE ALTER SYSTEM AUDIT SYSTEM AUDIT ANY 2.2.Debugging related System Privileges DEBUG ANY PROCEDURE DEBUG CONNECT SESSION 2.3. Index [...]
Published by Paresh Sarma //
Oracle Database Privileges are rights assigned to databases users , to perform some special actions on its own objects or other schema objects. In addition Oracle privileges are also enable a user to perform some system level operations, for examples connect to database,create table, altering database, delete table etc. Oracle Database Privileges are assign to [...]
Published by Paresh Sarma //
