Home » 2008 » July

Monthly Archives: July 2008

Advertisements

What’s most topic you want to see on this blog ?


Dear all blog visitors and RSS feeders,

On this posting, I would like to know what topic you want me to write ? Please give me any comment and I’ll try to post them for you.

I want to apologize for my late response on some question because I have problem on my internet connection and resource problem. So I would like to ask you to donate some of your money to help me maintain and update this blog regularly.

You can send donation to my paypal account : devratt@yahoo.com.

Best Regards,

Ardhian

Advertisements

Table Reorganization using BRSPACE via temporary tablespace


On my previous tutorial, you have already learned how to create new tablespace. I done it for this purpose. As you see, I already created PSAPIDS_REORG tablespace.

You can check it via DB02 tcode. Now, I want to reorg MSEG table. Right now, MSEG table is located on PSAPIDS tablespace. I check it by double click-in PSAPIDS from above screen. and write down MSEG on Object Name field like this.

Press the green check (v).

Here is information about MSEG table I get.

Now, open your MS-DOS prompt (coz I am using Windows based IDES server) and using [sid]adm user.

Type this command : >brspace -f tbreorg -t MSEG -m PSAPIDS_REORG

This command will reorg MSEG table and move it to PSAPIDS_REORG table.

Confirmation required to start reorganization process.

Table reorganization status starting.

Reorganization process has completed successfully.

To make sure that MSEG table has been moved to PSAPIDS_REORG tablespace, check again using DB02 tcode and check on PSAPIDS_REORG tablespace.

Now, you can see that MSEG table has been moved to PSAPIDS_REORG. You can start reorganize othe table. For your safety, use it on offline mode (no user access SAP server).