Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> System used as holiday camp!!

System used as holiday camp!!

From: <mleith_at_bradmark.co.uk>
Date: Wed, 3 May 2000 9:38:35 +0100
Message-Id: <10486.104772@fatcity.com> 





Hey Guys & Gals



Taking a look at a system tablespace today on one of our test machines, and=20=
it seems a user was created by sys!! Thus making this little blighters=20=
default tablespace=2E=2E you guessed it=2E=2E system=2E Now this oh so clever use=
r has=20=


created about 200 tables and indexes alike in the system tablespace!



What I am wondering is this, do any of you have a script that can delete all=20=
of a users objects from a tablespace? I don't want to play around to much=20=
with the system tablespace as my knowledge is limited=2E=2E=20=




Any insight is greatly appreciated!
Received on Wed May 03 2000 - 03:38:35 CDT












Original text of this message













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