DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Drop tablespace example

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Drop tablespace example

    Drop tablespace example

    I have installed oracle 9i by default, and i want to drop the tablespace example. But it contains materialize view and a lot of object, and because of that i cant just do a drop tablespace example including contents. Is There a document or a script made to drop that tablespace?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Try this.

    spool dropusers.sql
    SELECT DISTINCT 'DROP USER '||owner||' CASCADE;' FROM DBA_TABLES
    WHERE TABLESPACE_NAME = 'EXAMPLE';
    @dropusers.sql

    alter tablespace example offline;
    drop tablespace example;

    This will drop all of the schemas that use that tablespace and then drop that tablespace. Which is good as long as you don't have any real data stored there.

    Dropping a tablespace with including contents should drop the tablespace and everything in it regardless of RI, Triggers, or indexes.

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by gandolf989
    Try this.
    Dropping a tablespace with including contents should drop the tablespace and everything in it regardless of RI, Triggers, or indexes.
    Regardless of Triggers???? you meant to say, you want to drop system tablespace????
    -nagarjuna

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    EXAMPLE, NOT SYSTEM

Posting Permissions

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


Click Here to Expand Forum to Full Width