Import into partition table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import into partition table

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Import into partition table

    Hi,

    I have table without partition. I have another table with same structure with partition. I would like to pull data from the first table and import the same in the second partitioned tabel.

    1. Can I use exp and import utility? How?
    2. Does sqlplus 'copy' supports such scenario?
    3. What are the other best way to do from performance perspective? (without DB LINK)

    Thanks
    Sumit
    sumit

  2. #2
    Join Date
    Dec 2001
    Posts
    203
    Hi Guys

    Got it.

    It must be only table level export from the source and import to partition table.

    Thanks
    sumit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width