How I can Export and Import tables using BRTOOL ?

[Former Member]

Dear All,

Since we upgrade the oracle from 9.0.2 to 10.2.2 we not using SAPDBA any more.

please help me if you now how to export and import tables in sapr3 using brtools?

thanks and Best regards,

Chrisna

[Former Member · Accepted solution]

FYI,

I try using brspace like the screen below but this tools only can export the tablespaces not specifix tables see the log, any idea ?

brspace -f tbexport -o SAPR3 -s SSF_PSE_D,SSF_PSE_H,HTTPURLLOC -t "*"

BR1001I BRSPACE 7.00 (18)

BR1002I Start of BRSPACE processing: sdvmxgkb.tbe 2007-06-18 10.35.01

BR0280I BRSPACE time stamp: 2007-06-18 10.35.03

BR1009I Name of database instance: AC3

BR1010I BRSPACE action ID: sdvmxgkb

BR1011I BRSPACE function ID: tbe

BR1012I BRSPACE function: tbexport

BR0280I BRSPACE time stamp: 2007-06-18 10.35.12

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2007-06-18 10.35.32

BR0814I Number of tables/partitions in schema of owner SAPR3: 27628/9161

BR0836I Number of info cube tables found for owner SAPR3: 6153

BR0280I BRSPACE time stamp: 2007-06-18 10.36.04

BR0815I Number of indexes/partitions in schema of owner SAPR3: 42355/112015

BR0065E Tablespace 'SSF_PSE_D' not found

BR0065E Tablespace 'SSF_PSE_H' not found

BR0065E Tablespace 'HTTPURLLOC' not found

BR0182E Checking parameter/option '-s|-tablespace' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2007-06-18 10.36.05

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRSPACE time stamp: 2007-06-18 10.42.55

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:

[lbreddemann · Accepted solution]

Dear Chrisna,

first of all you should get the recent version of the BRTOOLS (currently it's BRTOOLS 7.00 (<b>26</b>)). The developers are working hard on making these tools more reliable and usable so you should not deny the improvements to yourself.

Now to your problem:

Try this call:

brspace -f tbexport -o SAPR3 -t SSF_PSE_D,SSF_PSE_H,HTTPURLLOC

You don't need to specify a tablespace; it's just a additional option to select what tables you like to export.

You may also want to check these notes for further "enlightment"

<a href="http://service.sap.com/sap/support/notes/976435">#976435 Support for Oracle Data Pump in BRSPACE</a>

<a href="http://service.sap.com/sap/support/notes/713497">#713497 - New BRSPACE options for "Reorg", "Rebuild" and "Tablespace"</a>

<a href="http://service.sap.com/sap/support/notes/647697">#647697 - BRSPACE - New tool for Oracle database administration</a>

<a href="http://service.sap.com/sap/support/notes/646681">#646681 - Reorganizing tables with BRSPACE</a>

<a href="http://service.sap.com/sap/support/notes/12741">#12741 - Current versions of BR*Tools and SAPDBA</a>

<a href="http://service.sap.com/sap/support/notes/651812">#651812 - FAQ: BR*TOOLS and SAPDBA</a>

KR Lars

[Former Member · Accepted solution]

Dear Lars,

Thanks alot for yours help and notes.

Thanks and best Regards,

Chrisna