|
-
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
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
|