Will database size be changed after Oracle Upgrade (from 8i to 10g)?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Will database size be changed after Oracle Upgrade (from 8i to 10g)?

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Will database size be changed after Oracle Upgrade (from 8i to 10g)?

    I am upgrading Oracle 8i to Oracle 10g for my client. A shared storage (EMC Disk system) wil be used for the upgrade.

    The database size for Oracle 8i is 80GB. (all files under oradata)

    I would like to know, will the database size remain more or less the same after data migrated to Oracle 10g (i.e. The database size for Oracle 10g is approx. to 80GB)?

    I need this figure to calculate the disk space for the EMC Disk System.
    Thank you very much if anyone could help!!!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    the database will remain about the same apart from adding a new sysaux tablespace and a new undo tablespace

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    I would like to know, will the database size remain more or less the same after data migrated to Oracle 10g (i.e. The database size for Oracle 10g is approx. to 80GB)?
    The size will be increased because the default initran value for table in 8i is 1, whereas it's 2 in 10g. I do not know migration utility will take care of this.
    Keep watch on big tables.

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