DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: DBA_SEGMENTS

  1. #1
    Join Date
    Jan 2000
    Posts
    21
    hi all,

    I'm seeing a rather unusual output from dba_segments. I've just migrated from Oracle7.3 to Oracle8.0.6. I got an error while running cat8000.sql that the table SYS.SOURCE$ has reached its max extents.
    So I run this query to make sure I'vent reached my max_extents and I get 2 rows. could anyone tell me why i've two entries for the same table in dba_segments view????

    SVRMGR> select initial_extent, next_extent, max_extents, extents
    2> from dba_segments where segment_name = 'SOURCE$';
    INITIAL_EX NEXT_EXTEN MAX_EXTENT EXTENTS
    ---------- ---------- ---------- ----------
    12288 1290240 249 12
    12288 12288 249 249
    2 rows selected.

    Thanks so much,
    vidhya

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    select the owner too, in my database there is only one (sys), but perhaps system owns an object of the same name.

  3. #3
    Join Date
    Jan 2000
    Posts
    21
    Duh! i didnt of think of that........thanks so much. Actually owner "Migrate" owns the other object.

    Thanks again,
    vidhya

  4. #4
    Join Date
    Nov 2000
    Posts
    71
    Your DB looks like having something corrupted.
    Try to execute this query and be sure to have only a record in your output (It should be sys).

    select owner from all_objects where object_name='SOURCE$';


  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You have reached maxextents for one of your system objects. While not the greatest thing to happen, it's not that big of a deal either. Just alter the object in question and set it's maxextents to unlimited. For example:
    alter table sys.source$ storage (maxextents unlimited).

  6. #6
    Join Date
    Jan 2000
    Posts
    21
    Hi,
    I get two entries for the same object in the all_objects view. One is owned by "migrate" and other one bu "sys". A question, since i've completed my migration is it appropriate to delete the user "migrate" and delete all the objects owned by this user???

    SVRMGR> select owner from all_objects where object_name='SOURCE$';
    OWNER
    ------------------------------
    SYS
    MIGRATE
    2 rows selected.

    Or is there a serious problem that "migrate" user owning objects that should be owned only by sys?

    when I count the number of objects owned by "migrate" result is 136

    SVRMGR> select count(*) from all_objects where owner = 'MIGRATE';
    COUNT(*)
    ----------
    136
    1 row selected.

    Thanks for all your help.
    vidhya

  7. #7
    Join Date
    Nov 2000
    Posts
    71
    Of course nobody else should be the owner of sys's objects.
    It'd be curious to know how you have an user with the same objects as sys user has.
    Howevere if your sys user work properly you can try to delete your user MIGRATE payinh attention if the DB work correctly.
    But it's not a nice situation.
    Good luck.

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