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

Thread: ORA-00972 and other problems with OEM 2.2

  1. 06-18-2003, 09:22 AM #1
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    ORA-00972 and other problems with OEM 2.2

    Hi Guys,

    My table Reorg job (Fixing Chained rows) in OEM (2.2.0.0.0) fails if the table length is more than 24 CHARS. This is because, it suffixes '$$TEMP' to the table name while creating a temporary table in which it inserts chained rows before deleting from the original table.

    The workaround is that every time, I need to change the table name and reduce it to <= 24 CHARS in the Reorg script.

    In OEM 2.2, if your table has Function based index (FBI) then also, its a problem. First you need to drop the FBI and then reorg that table. Another problem is that if the table has LONG/LOB column in it, you cannot do Reorg on that table.

    Has anyone faced these problems and is there any direct fix for those?

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  2. 06-19-2003, 08:39 AM #2
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Any ideas?
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  3. 06-20-2003, 02:04 PM #3
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi all,

    I guess nobody has got these problems. Am I correct?
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  4. 06-23-2003, 10:33 AM #4
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Guys,

    I guess, nobody uses OEM for reorganizing tables and fixing chained rows here. Am I correct?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  5. 06-23-2003, 10:40 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by samdba
    Am I correct?
    Might be
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    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