4 Replies Latest reply on Jan 28, 2013 3:43 AM by Aman....

    Moving table spaces from one 11gR2 instance to another

      Dears ,

      I have 11gR2 instance running and online in prod . There are some changes application which means some tables suppose to be moved to another instance of 11gR2 installed on same machine unix machine .Interestingly these tables and its indexes belongs to a set of tablespaces .So basically i need to do the following

      1. move all tables in table space TRANSACTION to new instance on same machine
      2. Move all indexes in table space TRANSACTION_IX to new instance on same machine
      3. drop tables and indexes in source instance .

      Size of the tables in tablespace is around 2TB .

      Basiaclly I am looking how can i do step1 and step 2 ? Is it possible to move index table spaces without re-creating it?

      Edited by: 984391 on Jan 27, 2013 8:35 AM