1 2 Previous Next 21 Replies Latest reply: Feb 7, 2013 3:08 AM by User13778505-Oracle RSS

    ORA-29857: domain indexes and/or secondary objects exist in the tablespace

    776040
      I tried to drop tablespace APPS_TS_TX_DATA using drop tablespace APPS_TS_TX_DATA including contents and datafiles cascade constraints.
      I got error ORA-29857: domain indexes and/or secondary objects exist in the tablespace.
      After I have dropped all domain indexes, then tried to drop tablespace again, I still got the same error. I have searched metalink regarding this error, there is no hit.
      What exactly objects in the tablespace are prevenng dropping the tablespaces?
        1 2 Previous Next