2 Replies Latest reply: Jan 17, 2013 2:21 AM by Salman Qureshi RSS

    Dependent objects import

    902332
      Hi all,

      we have one table and it's partitioned. it has 12 partitions. we need to import last two partitions only from that schema to another schema.

      if we export like $expdp dumpfille=x.dmp logfile=y.log tables=user1.table1:partition11, user1.table1.partition2

      does it exports tables structure also or does it only exports the data stored in that partitions.

      and while importing can we use the command like

      impdp dumpfile=x.dmp log=y.log tables=user1.table1:partition11, user1.table1.partition2

      and this table partitions are in different tablespaces. so does we need to create all the tablespaces and partitions on that target side also.

      Please suggest.
        • 1. Re: Dependent objects import
          moreajays
          Hi,

          It should create only partitions specified in the impdp , you can use remap_tablespace if need to point the partitions to diff. table spaces than that of original.
          Refer below

          http://www.dba-oracle.com/t_advanced_import_partition_options.htm

          Thanks,
          Ajay More
          http://moreajays.blogspot.com
          • 2. Re: Dependent objects import
            Salman Qureshi
            Hi
            does it exports tables structure also or does it only exports the data stored in that partitions.
            It will try to create the table (with create table statement including all partitions) and then do import of partitions data from the dump file. So if table is already there, it will return error and may keep on importing data, but, you need to manually create those partitions in the destination table which are being imported (if these partitions don't exist already).
            impdp dumpfile=x.dmp log=y.log tables=user1.table1:partition11, user1.table1.partition2
            You need to create partitions manually before importing if these partitions don't exist already.
            and this table partitions are in different tablespaces. so does we need to create all the tablespaces and partitions on that target side also.
            As told above, you need to create these partitions manually as import process will not create this partitions, you can create them any where in the database before import.

            Salman