Disk Space estimation Oracle - SQL Server

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  March 29, 2011 at 3:04 pm

  #389169

  am working on a migration project where we are migrating data from legacy systems to SQL Server. My question is if 100 tables with each 2 million rows of data is available under a oracle schema and when oracle database is queried for the disk space this schema is occupying, it gives 200Gigs.

  How much disk space a SQL server system would require, to host the same contents.

  is it 200gigs ? less or more ?

  Any reference to such an explaination would be appreciated.

  Please feel free to ask questions if I am not clear.

  [font="Verdana"]
  Today is the tomorrow you worried about yesterday:-)[/font]

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  March 29, 2011 at 3:28 pm

  #1305169

  You can run this in Oracle:

  select sum(bytes)/1024/1024 as "Used Space (Mb)" from dba_segments where owner='your_schema_owner';

  You can never be sure so double your storage.

  Alex S