Tuesday, February 14, 2017

Oracle 12.2 is Now Available on E-delivery

Oracle Just Announced the availability of Oracle database 12cR2 Exadata/SuperCluster On their website, In Case you want to upgrade :)


You can download oracle Enterprise edition 12cR2 from Oracle Edelivery Here 

Follow the steps :-



Enjoy
Osama

Sunday, February 12, 2017

Thursday, February 2, 2017

Import One table to the new name in the same schema

The following case just want to share it in case anyone need it, development wants to import the existing table in the siebel schema into the new name to check the data integrity:-

Oracle Provide you with Attribute called REMAP_TABLE Read More about it here.

Just Run the following command and change the variable depend on your environment :-

  • directory : The name of existing dump
  • dumpfile : The name of dump file
  • remap_table : Allows you to rename tables during an import operation
  • tables : the name of the table you want to restore it.



impdp directory=DMP_BAK dumpfile=31-01-2017_PRDSBL.dmp  remap_table=siebel.CX_PERMITS:CX_PERMITS_NEW tables=CX_PERMITS

Thanks
Osama