Where is my EXPORT dump file ? How to do BRTools off line table reorgan ?

[Former Member]

Hello,

Here was my BRTools Export output message :

About to export specified tables via Direct Path ...

Current user changed to SAPPRD

. . exporting table CDHDR 60357362 rows exported

Export terminated successfully without warnings.

BR0280I BRSPACE time stamp: 2011-08-09 16.53.04

BR1160I 1 table exported by EXP utility

BR0280I BRSPACE time stamp: 2011-08-09 16.53.04

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

But where is my Export dump file ?

Besides, could you tell me the procedures of using BRTools Export & Import to do off-line table reorgan ?

Due to some reasons, I can't do online table reorgan.

[Former Member]

Hi Ming,

Export file should be created under a directory under /oracle/<SID>/sapreorg. You can check *.tbe file under /oracle/<SID>/sapreorg, also.

Best regards,

Orkun Gedik

[Former Member]

Hi,

You can configure the export directory by setting exp_dump_dir parameter, in the init<DBSID>.sap file.

Additionally, please find the procedure, in order to export one or more tables, below;

brspace -u / -f tbexport -t "<Table name>"

Then continue to the process. At the end of the process, the system will export the table. You can find more information in the note 646681 - Reorganizing tables with BRSPACE

Best regards,

Orkun Gedik

[Former Member]

Thanks for your reply.

I found the Expoert dump file.

But how can I do off-line table reorgan. with BRTools Export and Import ?

I don't have any experience in off-line BRTools table reorgan with Export and Import.

(1)Use BRTools to export the CDHDR table,

(2)Generate table script from CDHDR ?

(3)Truncate CDHDR ?

(4)Re-create CDHDR with the script ?

(6)Use BRTools to import the Export dump file into the newly created CDHDR table ?

(7)Are there foreign keys in CDHDR ?

(8)If yes, how can I truncate its content ?

(9)Do you know any SAP Note or web sites give me step-by-step instrucations of using BRTools Export and Import to do off-line table reogranization ?

[Former Member]

Hi Ming,

I noted the OSS note 646681 - Reorganizing tables with BRSPACE in my previous message, already. You don't need any additional effort such as creating script, if you use brspace as I noted in my last message.

Stop the SAP system, but not database then execute the command, below;

1) brspace -u / -f tbreorg -t "CDHDR"

2) At the incoming menu steps, select --> (8 - Table reorganization mode (mode)) .. offline

3) Then continue with "c"

At the end of this steps, table and related indexes will be reorganized.

You can update statistics by using the command, below after you complete the steps, above respectfully;

brconnect -u / -c -f stats -t all -f collect -p 4

Best regards,

Orkun Gedik