Oracle Version: Oracle Release V6.1
Server: Strip Mill Micro Vax 3800
O/S: Open/VMS V5.2


Hello I am trying to change the block size on our PMT_RDB database.
At this point and time these are our block files:

plate_prod > DIR DUB0:[*...]PLATEMILL.*

Directory DUB0:[RDB_DATA.PMT]

PLATEMILL.RDA;1 ****** 28-SEP-2003 09:49:59.16
PLATEMILL.RDB;1 100 28-SEP-2003 09:49:58.98

Total of 2 files, 3424388 blocks.
plate_prod > DIR DUB1:[*...]PLATEMILL.*

Directory DUB1:[RDB_SNP.PMT]

PLATEMILL.SNP;1 10002 28-SEP-2003 10:33:12.67

Data Page Count:
===========

plate_prod > RMU/DUMP/HEADER PMT_RDB/OUTPUT=PMT_RDB.HDR
plate_prod > EV PMT_RDB.HDR

Storage area "RDB$SYSTEM"
Area ID number is 1
Filename is "RDBDSK0:[RDB_DATA.PMT]PLATEMILL.RDA;1"
Access mode is READ/WRITE
Pages...
- Page format is uniform
- Page size is 2 blocks
- Initial data page count was 1710000
- Current physical page count is 1712143
- Row level locking is enabled

I used this solution to solve this problem:

(1) SQL> EXPORT DATABASE FILENAME pmt_rdb INTO pmtexp;
SQL> IMPORT DATABASE FROM pmtexp FILENAME pmt_rdb ALLOCATION IS 500000
PAGES;

The import command allocated the same space as before it did not change the
block size it's still at:
Total of 2 files, 3424388 blocks.

How come it came back with the same block size? Did I miss something?

Thanks

Billy Tremonte wrote:

Really??? VMS 5.2??? I thought the minimum VMS version for Rdb 6.1 is
5.5-2.


This is easy

Current physical page count is 1712143
* 2 blocks per page = 3424388 (plus or minus due to disk cluster
factor -- sh dev dub0/full - look for cluster size )

A BLOCK is ALWAYS 512 bytes
A PAGE can be n Blocks
Space used is BLOCKS per PAGE * Number of PAGES

The only way to reduce the number of blocks is to delete data... and I
really don't think you want to do that... maybe you do... then you can
try your export/import after you have deleted lots of data....

BTW isn't it about time to upgrade?

Michael Austin

Michael Austin wrote:
Both Software and Hardware. RDB on a 3800 would crawl compared
to running RDB on VMS on CHARON-VAX on a new PC.

--
Peter Weaver
Weaver Consulting Services Inc.
Canadian VAR for CHARON-VAX
www.weaverconsulting.ca