-
We are doing 650Gb database migration from 8.0.5 over to 9iR2 using 2 different boxes.
The source 8.0.5 database has 4Kb block size and a particular table partition allocates 2.2 million blocks for 10 million records. The pctfree for the partition is set to 5 and the table has one numeric column, three varchars (1 or 2 characters each) and four RAW(2000) columns.
Destination 9.2 database has 16Kb block tablespaces and the same partition allocates 1.4 million blocks with pctfree 1.
Looks like with larger blocks table allocates 3 times more space than in 4K block database.
The question is where I am losing space?
Sergey Popov
National Processing Company, LLC
Louisville, KY
-
Some question:
Which character set is using in old database and whitch
in new?
Then:
Did u analize both tables (new/old) and ca u post result of
analize?
-
Originally posted by Shestakov
Some question:
Which character set is using in old database and whitch
in new?
Then:
Did u analize both tables (new/old) and ca u post result of
analize?
8.0.5 database has US7ASCII char set and 9.2 has WE2MSWIN1252.
Analyze table is in progress
Thanks,
Sergey.
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
|