How to Refresh a Table ?

1. Check the size of the Table in Dev.

 SQL> select sum(bytes/1024/1024/1024) from dba_tables where tablename='EMP';

SUM(BYTES/1024/1024/1024)
-------------------------
                .00012207

2. check the free tablespace size in target  database by using dba_freespace

3. Export the Table

  

   $ expdp dumpfile=emp.dmp directory=export tables=rms12.emp logfile=tables_emp.log

4. Copy the Dump file to target server

    $ scp dumpfilename username@target servername:/u01/backup/export

5. import the table

     $ impdp dumpfile=emp.dmp directory=import tables=rms12.emp

Note : Table_exist_action = Skip or Replace or append or turncate

                                                Thank You