Database Solutions

Oracle Data Migration with expdp and impdp For Oracle DBA data migration using Export Import is common activity in day to day activity. Either you need to migrate data from Different version of oracle or between two different platform like windows server o linux platform. Export import is used mostly but require complete downtime for the database migration. In this blog ,We will share the steps to migrate the database from one database to another database using export and import.  Below steps can be used for the same: 1) Create an empty database in target server and make sure database is in noarchive log mode.  Make sure that the parameter for the source and target databases are same.  Make list of application tablespace from source database to target database. You can get the DDL for all tablespaces in source databases using below command: SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN    DBMS_METADATA.set...

Oracle Export-Import - Refresh Table For DBA  Refreshing Table , Schema and Database are routine activity. You can  refresh/Clone  database using below method: 1.Conventional Restore method and Rename DB post DB Refresh 2. Conventional Duplicate Database method 3.  Active database Cloning  4. Backup Base Cloning In Todays blog , We will discuss about how to refresh table from one database to another database.  Below are the Steps to refresh table: 1)Export the XXX.XXX_DATA table on Source Database   expdp \"/ as sysdba\" directory=DATAPUMPDIR logfile=XXXX_XXX_adhoc_180113.log dumpfile=XXXX_XXXX_adhoc_180113.dmp tables=XXX.XXXX_DATA 2) SCP the backup dump to target server . 3)At Target Database ,Take the export backup of the existing table as below. expdp \"/ as sysdba\" directory=DATAPUMPDIR logfile=XXXX_XXXX_adhoc_backup_180113.log dumpfile=XXXX_XXXX_adhoc_backup_180113.dmp tables=XXX.XXXX_DATA 4) Finally Import it as below impdp \"/ as sysdba\" dir...