How to Delete Table, Index, Schema Statistics?

Here are the commands to delete the statistics. 

EXEC dbms_stats.delete_table_stats('<TALE OWNER>', '<TABLE NAME>');

EXEC dbms_stats.delete_table_stats(OWNNAME=>'<TALE OWNER>', TABNAME=>'<TABLE NAME>');

DataPump EXPDP Estimate [ BLOCKS | STATISTICS ]Option

This parameter is used to estimate the amount of disk space used by each table in the export. This would be an approximate value. There are two options for this parameter. 

How to Check User Quota on Oracle Tablespace - DBA_TS_QUOTAS

The base dictionary view is DBA_TS_QUOTAS to fetch the specific tablespace user quota details. MAX_BYTES column value -1 means unlimited quota for the user for the particular tablespace.

DataPump Expdp KEEP_MASTER Option

Master Table:- Master table is the key table for the data pump jobs. It keep track of the respective datapump jobs. The table name is same as the job name of the export or import job.

Oracle 12c 18c 19c: How to find out the Listener.log file location?

In latest versions of Oracle the listener.log file placed under the ADR_BASE/diag folder.

DataPump Expdp ORA-39071: Value for EXCLUDE is badly formed

Problem Description: 

Datapump export command failed with following error.


This parameter determines the algorithm to compress the dump file data. 


DataPump Expdp ABORT_STEP Option

ABORT_STEP is the option with the DataPump export utility (expdp) to stop the job after the initialization. This is available from 

Oracle CDB PDB: ORA-65096: invalid common user or role name; Create user Command failed

Problem Description:

SQL> create user "mytest" identified by mytest;
create user "mytest" identified by mytest
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL Script to Find out Current Running Active, Inactive Sessions Connected to the Database

This is the one of the most useful queries which is used by the DBAs on daily basis. Here I have provided multiple queries which can be used for finding out Active, Inactive with RAC and Non-RAC databases. 

How to Remove / Delete / Drop a Machine from Oracle VM Virtual Box?

Step 1.
Stop /power off the running VM by right clicking the running virtual Machine.

iPhone - How to Call Non-emergency Number from Locked iPhone Without Knowing Password?

I hope this would be an interesting feature to know. Suppose you lost your iPhone and somebody might have found it or in some emergency your friends or colleagues wanted to contact your family member,


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer