ORACLE 8 - Export - Import

[jorge_velasquez]

Hi Experts,

I want to do an export - import of my Oracle DB. As I understand this could reduce my DB size.

What method do you suggest?

Can I use SAPINST 7.00 for the export -import? my SAP is 4.5B

It´s the same SAP System ID and the same server I just want to reduce my DB size.

Regards

[markus_doehr2 · Accepted solution]

> I want to do an export - import of my Oracle DB. As I understand this could reduce my DB size.

This process is called "reorganization" and is only necessary if lots of data was deleted. Just exporting and importing doesn't do any change.

> Can I use SAPINST 7.00 for the export -import? my SAP is 4.5B

SAPINST doesn't know about 4.5B, this is LONG gone.

Oracle 8 and 4.5B are long out of maintenance, nowadays available tools don't support such old ancient versions. You would need to do that using sapdba or write your own scripts.

Markus

[jorge_velasquez · Accepted solution]

Hi Markus,

Is there a way to use BRTOOLS in Oracle 8?

The reorganization could be this way?:

-Export

-Drop tablespace

-Create Tablespace with new size

-Import

Regards.

[former_member204746 · Accepted solution]

you are using Oracle 8 with old SAP 4.5b.

you will need to use the old SAPDBA to do this.