article-preview

ALTER DATABASE

ALTER DATABASE
 (1) Required Privileges

You must have the ALTER DATABASE system privilege.To specify the RECOVER clause, you must also have the SYSDBA system privilege.

(2) Adding Redo Log File Groups:

article-preview

CASE STUDY 1

CASE STUDY 1
 How to Handle Materialized View Refresh Performance?
(From the personal experiences of JP Vijay Kumar)
The issue on hand:
A materialized view created on a remote master table is taking 23 seconds for fast refresh.

article-preview

EXPORT

EXPORT
 Export Utility enables you to take a snapshot of the database basing on the flexibility preferred/chosen by the user and generates a single file or multiple files of the size chosen by the user.

article-preview

RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS)

RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS)
 Data is organized in tables defined by the relations of the data into organized tables.

Tables can have Primary AND/OR Unique keys.