This discussion is archived
2 Replies Latest reply: Jan 17, 2013 12:21 AM by SalmanQureshi RSS

Dependent objects import

902332 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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
    SalmanQureshi Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points