Thanks Rohit and Sairaj.

For Rohit, I just test your script and gives me the error
below. I'm not sure what the errors are. Also, I'm not
familiar with the word COMPILE. Would you kindly
explaining to me what the COMPILE does? I really appreciate
it.


ALTER PACKAGE BODY MDSYS.MDEXEX COMPILE
*
ERROR at line 1:
ORA-00922: missing or invalid option

ALTER TYPE MDSYS.SDO_ELEM_INFO_ARRAY COMPILE
*
ERROR at line 1:
ORA-02311: cannot alter with COMPILE option a valid type with type or table
dependents


ALTER TYPE MDSYS.SDO_ORDINATE_ARRAY COMPILE
*
ERROR at line 1:
ORA-02311: cannot alter with COMPILE option a valid type with type or table
dependents