CODEWITHSUNDEEP
oracle-databaseresizeshrinkopenvmsoracle-rdb
IKJ
IKJ

Reputation: 11

Shrink Oracle RDB database on OpenVMS

I have inherited a legacy OpenVMS system with an Oracle RDB database. Recently due to the backup size becoming stupidly large we have archived some of the older data out of the production database. Now we need to shrink the actual database files but are not sure how to go about this.

I have a vague memory of watching someone else unload/export and reload/import data in order to achieve this in the past (sadly he is no longer around to ask).

Ideally what I need is a step by step of how to do this.

Upvotes: 1

Views: 521

Answers (1)

user2915097
user2915097

Reputation: 32176

Basically you will want to do

mc sql$ export database filename ''base' into ''fil_export'; exit

and then, if it has been successful, drop the database

mc sql$ drop database filename ''base';

Now you import it

mc sql$ import database filename ''base' from ''fil_export';

This is explained in detail in the Oracle RDB docs, for example the

Oracle Rdb™ SQL Reference Manual Volume 4

avalable here for example

download.oracle.com/otn_hosted_doc/rdb/pdf/sql_ref_v72_part4.pdf

Upvotes: 1

Related Questions