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

Thread: making table unusable

  1. #1
    Join Date
    Apr 2002
    Posts
    34

    making table unusable

    Hi

    How can I make a table unusable without dropping tha table from the database?

    Regards

    Raju

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    1) Drop all the columns
    2) Revoke all privs on the table
    3) Threaten physical injury on anyone that uses "your table"!
    3) Drop the database
    5) Kill all the users
    6) Lock it
    7) Shutdown the database.

    How many guesses do we get anyhow?
    I guess #2 is the safest one, some may go for the more "adventurous" alternatives.


    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Mr.Hanky
    some may go for the more "adventurous" alternatives.


    MH
    Like deleting entry from SYS.OBJ$.....

    /* raju_sbd : Dont Try this any way */
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Rename the table.

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