Re: Q: Delete Schema Objectas

From: Frenchy461 <frenchy461_at_aol.com>
Date: 7 Oct 1998 20:37:24 GMT
Message-ID: <19981007163724.13634.00007220@ng-fc2.aol.com>

If the only objects, are tables and indexes and they are in their own respectfull tablespaces; you could drop the tablespaces including contents.

If this is not the situation, writing SQL to create the SQL to drop objects would be my next bet.

Objects in question:
tables
constraints
indexes
views
synonyms
public synonyms
Look at other instances to see if Database links have been created. .... Received on Wed Oct 07 1998 - 15:37:24 CDT

This message: [ Message body ]
Next message: hr784_at_cleveland.freenet.edu: "Oracle Web Application Server 3.0.1 question"
Previous message: carkb_at_my-dejanews.com: "How good is Oracle Change management Tool?"
In reply to: Matthias Gresz: "Q: Delete Schema Objectas"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US