Hi, Sometimes You can get ” ORA-20000: Insufficient privileges to Analyze an object in Schema ” error during Gather DBMS_STATS Database, Schema, Table and Dictionary Stats.
Read More »
What about if you could organize your database objects (e.g. tables and views) in namespaces according with its roles in the system? In this article we will see the …
Read More »
Hi everyone, Today i will show you how to create tablespace on Oracle Database. I installed Oracle database with GRID , so i created ASM disk that means data files …
Read More »
Hi everyone, i want to show you schema subject, system and user privileges. it seems easy but required for dba SCHEMA : Schemas are called database objects aggregated together. A …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial