Database Solutions

Transport tablespace is a feature of oracle database which is used to migrate application data from database to another database. Transportabletablespace is a much-awaited new feature available in Oracle 8.1.5. This feature allows users to export the metadata of the tablespace instead of the data in the tablespace. By doing so, the consistent backup of the tablespace concerned could be transferred to the desired location and straightaway plugged in by importing the meta data instead of importing the whole data. This feature is very useful for data warehousing/applications which needs data to be distributed to various places. Using this feature, we can reduce the time required to export import the data. Transportable tablespace can also be used with RMAN , TSPITR. The examples given in this note are from NT. But the steps are identical even in Windows NT like any other Oracle Operations.   RESTRICTIONS 1. Operating system and processor type must be the same at source and targ...

For Oracle DBA database migration  is common activity in day-to-day activity. Sometimes We need to migrate only one application data in the database. Though we can so such migration with expdp/impdp but sometimes we have a requirement of migrating data with low or no downtime. That's where Transport tablespace with zero downtime come into picture.  In this blog we will show how we can perform the migration of tablespace with zero downtime.  1) Perform the  integrity check for tablespcae execute dbms_tts.transport_set_check('CON_RPT_DATA,CON_RPT_INDEX',TRUE); Make sure there is no violations.  2) In order to start actual migration, we need to create auxillary database. For that we need to create auxialiary database parameter file. ( Remember   DBNAME can be same as source,  but unique name for DB needs to be different) cat auxinst.ora db_name=TEST3BD compatible=11.2.0.4.0 db_unique_name=PERCTEST db_block_size=8192 db_files=200 sga_target...