Mir Sayeed Hassan – Oracle Blog

Reorganizing or Shrink table/index in Oracle 11gR2 DB

A Simple demonstration to perform shrinking the object in Oracle Database 11gR2

[oracle@testdb ~]$ !sq

SQL> conn mir/****
Connected.

SQL> create table shrink_test as select 'Oracle_shrink_method' as product, mod(rownum,5) as... 
Read more..			

Clear old alert in Enterprise Manager (EM) in Oracle Database

Given alert shows the old alert which is not require to be present in database, Hence need to clear manually as shown below:

How to connect Oracle 12c database (CDB and PDB) 

• Container Database (CDB)
• Pluggable Database (PDB)

[oracle@ora12c ~]$ !sq
sqlplus / as sysdba

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> select... 
Read more..			

How to export partition table by using expdp

 Consider the below example tested in our test env & verified

Create the directory at OS Level to place the backup of the dumpfile

[oracle@testdb backup]$ mkdir db_dump_bkp

[root@testdb backup]#... 
Read more..			

How to export schema with compression method by using expdp

Consider the below example tested in our test env & verified

Create the directory at OS Level to place the backup of the dumpfile

[oracle@testdb backup]$ mkdir db_dump_bkp

[root@testdb backup]# chmod -R 777 db_dump_bkp/

Create...
Read more..