+ Reply to Thread
Results 1 to 4 of 4
  1. 03-02-2001 12:00 PM #1
    trogen
    trogen is offline Junior Member
    Join Date
    Jul 2000
    Posts
    70
    My database has a lot of default users such as tracesvr, scott, Blake,adams, clark, jones, etc,
    that I didnt really create.
    All of them have their default tablespace as system.
    DO i really need them or are they just occupying space, because my system table space is used upto 96%
    thanks.

    Reply With Quote Reply With Quote
  2. 03-02-2001 12:59 PM #2
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I think it might be used for the Trace utility, not sure though.
    Reply With Quote Reply With Quote
  3. 03-02-2001 01:05 PM #3
    adrianomp's Avatar
    adrianomp
    adrianomp is offline Senior Member
    Join Date
    Feb 2001
    Posts
    295
    Scott, Blake, Adams, Clark, Jones (and a few tables like EMP, DEPT, SALGRADE) are created by a script included in Oracle. They're from demonstration purpose only, the Oracle's training exercises are based on these users/tables. Probably you executed the script during installation.

    You can drop'em all.


    Adriano.
    Reply With Quote Reply With Quote
  4. 03-03-2001 02:19 PM #4
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    All you wanted

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6215[/url]
    Reddy,Sam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width