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

Thread: Oracle 6 DB support

Threaded View

  1. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by SandLake
    (I know an Oracle 6 DB is past its sell by date - but a shiny new system is on the horizon)
    Oracle 7 is past its sell date, 6 is ancient.

    I know from Oracle 7.3.4 that the number of extents is related to the block size. So a 4K block size will give you 121 extents, i would make a guess and say that somehow you are dealing with 2K block sizes. So you might need to drop the constraints on the table, rename the table and create a table that will put everything in one extent and provide room to grow. You want to make sure that you know how to create the table and its extents before you start.

    You can also do an export with compress turned on drop the schema create the user with all its grants and reimport the data. This will make the extents such that each object will fit in one table. This may cause issues with fragmentation on your tablespaces.
    Last edited by gandolf989; 10-21-2008 at 10:57 AM.

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