DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: exchange partition

  1. 03-09-2005, 10:24 AM #1
    lgaorcl
    lgaorcl is offline Senior Member
    Join Date
    Jun 2000
    Posts
    315

    exchange partition

    I have a small table with clean data for year 2005. Now I wanted to exchange this table with a partition p2005 in a composite partitioned (range-hash) big table. But I got error ORA-14292: Partitioning type of table must match subpartitioning type of composite partition.

    Do I have to have small table2005 composite partitioned in order to be exchanged? That would require quite a log of space.

    Thanks!
    Reply With Quote Reply With Quote
  2. 03-09-2005, 11:01 AM #2
    OracleDoc's Avatar
    OracleDoc
    OracleDoc is offline The Doc is in!
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Any possiblity to paste up the sql syntax you're using to give me (us) a better insite of what you're trying to do.

    I'm sooo funcused ??
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg
    Reply With Quote Reply With Quote
  3. 03-09-2005, 11:13 AM #3
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Yes, your small table must be hash partitioned -- but I don't understand why that would take up much more space than the non-partitioned table
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  4. 03-09-2005, 11:29 AM #4
    lgaorcl
    lgaorcl is offline Senior Member
    Join Date
    Jun 2000
    Posts
    315
    Thanks for the help! I just realized that composite potitioned table cannot exchange partition.
    Reply With Quote Reply With Quote
  5. 03-11-2005, 03:49 PM #5
    lgaorcl
    lgaorcl is offline Senior Member
    Join Date
    Jun 2000
    Posts
    315
    Now, I am doing an exchange partition with an list partitioned table, instead of composite partitioned table. But I still can not get through it. I got ora-14099: all rows in table do not qualify for specified partition.
    What are the conditions to be qualify for a partition exchange?

    Help me! It's frustrating!
    Reply With Quote Reply With Quote
  6. 03-17-2005, 12:23 AM #6
    hanselrl
    hanselrl is offline Junior Member
    Join Date
    Mar 2001
    Posts
    41
    Make sure that all the column definitions of the two tables are the same. Same with the indexes if u want it to be included during the exchange.
    Reply With Quote Reply With Quote
  7. 03-17-2005, 01:28 AM #7
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by lgaorcl
    Thanks for the help! I just realized that composite potitioned table cannot exchange partition.
    Yes it can -- but the table with with the composite partition is exchanged must itself be partitioned in a manner compatible with the method of subpartitioning in the composite table.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  8. 03-17-2005, 01:30 AM #8
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by lgaorcl
    Now, I am doing an exchange partition with an list partitioned table, instead of composite partitioned table. But I still can not get through it. I got ora-14099: all rows in table do not qualify for specified partition.
    What are the conditions to be qualify for a partition exchange?

    Help me! It's frustrating!
    The error message is self explanatory -- some rows in the table which you are exchanging the partition with are not properly part of that partition -- like your partition is for values 'EAST' and the table has rows with a value of 'WEST'
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width