RE: OEM Table Reorg

            I’m running 12c, I’m bad too! I don’t get to that page because I don’t have a working O/S login. OEM cannot handle LDAP.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930 (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Courtney Llamas Sent: Thursday, September 07, 2017 11:35 AM To: niall.litchfield_at_gmail.com; ORACLE-L Subject: RE: OEM Table Reorg

Yes, you should have upgraded by now Niall! ;)

I can confirm in 13c, we still show the script in the last step, just before you submit the job to run. You can always cancel out at this time and run the script manually. Will provide summary and full script.

It’s not just a right click and create reorg script, but then again OEM is never meant to be just a code generator, it’s built to execute for you.

[cid:image001.png_at_01D327EF.A88630F0]

--
- Courtney
[Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=ZxXpWrJKaDGwGf-hhHgufJiJ7n2AS_H9h-fITIMQmho&s=AhpuyE3k6CEtMQsHpdtxbnZtJ4ZF9LNSfILED_xs27k&e=> Courtney Llamas | Consulting Member of Technical Staff Phone: +2814108258<tel:+2814108258> | Mobile: +8324720596<tel:+8324720596> Oracle Strategic Customer Program

Oracle
[Green Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_commitment&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=ZxXpWrJKaDGwGf-hhHgufJiJ7n2AS_H9h-fITIMQmho&s=67ouFaklQXqBfsOPkjuytEiwfR-ia2DzLxHR5R4Rd94&e=>

Oracle is committed to developing practices and products that help protect the environment

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Thursday, September 07, 2017 10:24 AM To: ORACLE-L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Re: OEM Table Reorg

Hi

What do you mean by OEM reorg? The tablespace reorganization wizard in Cloud Control 12.1.0.4 (my version and yes Courtney I should have upgraded long ago) does allow you both to view and down load the script at the last stage. I'd be surprised if this had been removed at a later release.

On Thu, Sep 7, 2017 at 3:12 PM, Reen, Elizabeth <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> wrote:

            OEM reorg does not have an option to see the script before it is run. We have LDAP accounts which OEM does not understand. I would like to get the script so I can run it by hand. Is there any way to do this?

Liz

Elizabeth Reen
CPB Database Group Manager

--
Niall Litchfield
Oracle DBA
http://www.orawin.info<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=uj8E8tbHWUbA47HiUmp8r97D9sNxWplHIo581sGFuJQ&m=RsBaKgHJAXY3PJUhbXkUaO6OjVNDKwbMOy6aPDf22KY&s=gYV6GgNZ_OWhRwCXC2LKNg8UDU-QtP16dE6GJfHmEoA&e=>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png





(image/gif attachment: image002.gif)




(image/gif attachment: image003.gif)