Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    8

    Unanswered: Drop EXAMPLE schema

    Hi all

    I've been trying to drop the example tablespace without success. Here's my intended script:

    -------------------------------------------------------------
    DROP USER QS CASCADE;
    DROP USER SH CASCADE;
    DROP USER HR CASCADE;
    DROP USER OE CASCADE;
    DROP USER PM CASCADE;

    DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
    -------------------------------------------------------------

    Problem occurs when I tried to drop QS user, the error says
    "ORA-24008: queue table QS.QS_ORDERS_PR_MQTAB must be dropped first"

    Further investigation suggested we execute the ORACLE_HOME/demo/schema/shipping/qs_drop.sql
    http://www.lc.leidenuniv.nl/awcourse...9/installa.htm
    The script ended up with more queue table problem.

    Any suggestion is greatly appreciated.

    Cheers
    -WK-

  2. #2
    Join Date
    Oct 2004
    Posts
    4
    Took a quick look a Metalink this "may" apply.
    Note 283926.1 suggests a possible bug in 8.05 to 9.2.03
    References note 236898.1 for instructions on how to work around.

    KenF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •