Results 1 to 2 of 2

Thread: Dropping tables

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    Unanswered: Dropping tables

    Is it possible to drop tables which are owned by a particular user whose applications are no longer needed?
    I have tried--
    drop table *
    from all_tables
    where owner = upper('theusersname')

    the only other way I could drop their tables was to drop the user.
    thanks for your input.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is it possible to drop tables which are owned by a particular user whose applications are no longer needed?
    YES, but you need to use valid SQL syntax which can be found by reading the fine SQL Reference manual found at http://tahiti.oracle.com
    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.

Posting Permissions

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