Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Question Unanswered: Query to remove tables, trigger stored procedures in oracle DB?

    Is there any single query to remove all tables, triggers, stored procedures in oracle DB?


    Best Regards,
    Mushq

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there any single query to remove all tables, triggers, stored procedures in oracle DB?
    Is this "DB" a DB in Oracle terms or DB in meaning as SQLServer or MYSQL?
    But the short answer is NO; except when
    DROP USER <USER_NAME> CASCADE;
    is acceptable to use.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Formatting the hard drive will always work.

    But seriously, what exactly do you want to do? remove all objects for a specific schema or remove the schema it self.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    It is (always?) easier to drop user; otherwise, there's (always?) something left and schema isn't really empty (you know, tables and views and procedures and triggers are dropped; then you find out that you "forgot" to drop snapshots or types or sequences or jobs or ...).

  5. #5
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    It is (always?) easier to drop user;
    Just don't forget to record any system privs, roles, quotas, direct table privs granted to the user before dropping the user...

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As you've seen, I have two (always?)es in there. I don't know what smells worse ... crap or shit.

  7. #7
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    Such profanity! Yes, I did notice your strategically placed (always?)es in there...

Posting Permissions

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