SET SERVEROUTPUT ON
DECLARE

   V_COLS                VARCHAR2(20);

BEGIN

           FOR CUR_CCD IN(SELECT DISTINCT TABLE_NAME,OWNER FROM ALL_TABLES
                               WHERE OWNER LIKE 'CCD_MAIN'
                               )
           LOOP
                   FOR CUR_USR IN(SELECT DISTINCT TABLE_NAME, OWNER
                                FROM ALL_TABLES
                                AND OWNER NOT LIKE 'CCD_MAIN'
                                ORDER BY 2)

                       LOOP

                            FOR CUR_COL IN (SELECT DISTINCT COLUMN_NAME  FROM
                                 (SELECT DISTINCT COLUMN_NAME  FROM
                                  ALL_TAB_COLUMNS
                                  WHERE TABLE_NAME = CUR_CCD.TABLE_NAME
                                  AND OWNER=CUR_CCD.OWNER
                                  MINUS
                                  SELECT DISTINCT  COLUMN_NAME FROM
                                  ALL_TAB_COLUMNS
                                  WHERE TABLE_NAME = CUR_CCD.TABLE_NAME
                                  AND OWNER =CUR_USR.OWNER))
                           LOOP

                           DBMS_OUTPUT.PUT_LINE(CUR_USR.OWNER||' : '||CUR_CCD.TABLE_NAME||' :'||CUR_COL.COLUMN_NAME);

                           END LOOP;

                           END LOOP;
           END LOOP;

END;
/

SET SERVEROUTPUT ON
BEGIN
  FOR cur_tab IN
    (SELECT DISTINCT ccd.owner ccd_owner, ccd.table_name ccd_table_name, usr.owner usr_owner
     FROM   all_tables ccd, all_tables usr
     WHERE  ccd.table_name = usr.table_name
     AND    ccd.owner != usr.owner
     AND    ccd.owner = 'CCD_MAIN'
     ORDER  BY ccd.table_name, usr.owner)
  LOOP
    FOR cur_col IN 
      (SELECT column_name  
       FROM   all_tab_columns
       WHERE  owner = cur_tab.ccd_owner
       AND    table_name = cur_tab.ccd_table_name
       MINUS
       SELECT column_name
       FROM   all_tab_columns
       WHERE  owner = cur_tab.usr_owner
       AND    table_name = cur_tab.ccd_table_name)
    LOOP
      DBMS_OUTPUT.PUT_LINE
        (cur_tab.usr_owner      || ' : ' || 
         cur_tab.ccd_table_name || ' :'  || 
         cur_col.column_name);
    END LOOP;
  END LOOP;
END;
/

SELECT DISTINCT usr.owner, ccd.table_name, ccd.column_name
FROM   all_tab_columns ccd, all_tab_columns usr
WHERE  ccd.table_name = usr.table_name
AND    ccd.owner != usr.owner
AND    ccd.owner = 'CCD_MAIN'
AND    EXISTS
       (SELECT atc1.column_name  
        FROM   all_tab_columns atc1
        WHERE  atc1.owner = ccd.owner
        AND    atc1.table_name = ccd.table_name
        AND    atc1.column_name = ccd.column_name)
AND    NOT EXISTS
       (SELECT atc2.column_name
        FROM   all_tab_columns atc2
        WHERE  atc2.owner = usr.owner
        AND    atc2.table_name = ccd.table_name
        AND    atc2.column_name = ccd.column_name)
ORDER  BY ccd.table_name, usr.owner
/

SET SERVEROUTPUT ON
DECLARE
V_COLS                VARCHAR2(20);
BEGIN

                   FOR CUR_CCD IN(SELECT DISTINCT TABLE_NAME,OWNER 
                                  FROM ALL_TABLES
                                  WHERE OWNER LIKE 'CCD_MAIN')
                                      
                   LOOP
                           FOR CUR_USR IN(SELECT DISTINCT TABLE_NAME, OWNER
                                          FROM ALL_TABLES
                                          WHERE OWNER LIKE '%_MAIN'
                                          and OWNER NOT in ('CCD_MAIN','SYS','SYSTEM','OUTLN','SCOTT')
                                          and table_name = cur_ccd.table_name
                                          ORDER BY 2)

                        LOOP

                                    FOR CUR_COL IN (SELECT DISTINCT COLUMN_NAME  FROM
                                                              (SELECT DISTINCT COLUMN_NAME  
                                                              FROM  ALL_TAB_COLUMNS
                                                              WHERE TABLE_NAME = CUR_CCD.TABLE_NAME
                                                              AND OWNER=CUR_CCD.OWNER
                                                              MINUS
                                                              SELECT DISTINCT  COLUMN_NAME 
                                                              FROM ALL_TAB_COLUMNS
                                                              WHERE TABLE_NAME = CUR_CCD.TABLE_NAME
                                                              AND OWNER =CUR_USR.OWNER))

                                           LOOP
                                            
                                            DBMS_OUTPUT.PUT_LINE(CUR_USR.OWNER||' : '||CUR_CCD.TABLE_NAME||' : '||CUR_COL.COLUMN_NAME);

                                           END LOOP;
                               END LOOP;
                   END LOOP;
        END;
        /

ENWEBP1P > @last_ddl.sql
Enter value for like_object_name: %
Enter value for like_object_type: view
Enter value for like_owner: %
Enter value for days_to_look_back: 10

CREATED   LAST_DDL             OWNER           OBJECT_NAME                    OBJECT_TYPE
--------- -------------------- --------------- ------------------------------ -----------
06-JUN-12 19-DEC-2012 10:28    SITE_USER       ECM_RELATED_IMAGES             VIEW

1 row selected.

ENWEBP1P > list
  1  select created,
  2  to_char(last_ddl_time,'DD-MON-YYYY HH24:MI') Last_ddl,
  3  owner,object_name,object_type ,subobject_name
  4  from all_objects
  5  where object_name like upper('%&like_object_name%')
  6  and object_type like upper('%&like_object_type%')
  7  and owner like upper('%&like_Owner%')
  8  and last_ddl_time > sysdate-&days_to_look_back
  9  and owner not like 'SYS%'
 10* order by last_ddl_time

SQL> select last_ddl_time from user_objects where object_name='T';
LAST_DDL_TIME
-------------------
11/12/2012 08:30:39

1 row selected.

SQL> grant select on t to scott;

Grant succeeded.

SQL> select last_ddl_time from user_objects where object_name='T';
LAST_DDL_TIME
-------------------
20/12/2012 08:15:18

1 row selected.

SQL> revoke select on t from scott;

Revoke succeeded.

SQL> select last_ddl_time from user_objects where object_name='T';
LAST_DDL_TIME
-------------------
20/12/2012 08:15:50

1 row selected.