Skip to Content
author's profile photo Former Member
Former Member

table space

Hi

We have ARFCSSTATE table size as 20 gig

I have removed the entries in ARFCSSTATE table using a report

now ARFCSSTATE table is empty

But its not showing up

I know for this we need to use brtools

Can anyone tell me what options should I select in BRTOOLS

thanks

Jameel

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 12:28 PM

    Hi Jammel,

    If you are on oracle 9i then you can reorganize online no need to shut down SAP.

    But reorganizing tables will only show increase in the Free space and total DB size will be same in DB02.

    Think of reorganizing tablespace for getting desired changes.

    Regards

    Umesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 11:09 AM

    Hi Jameel,

    1) If you have deleted all the table entries of ARFCSSTATE then you can use TRUNCATE table command to free up the space.

    2) If you have not deleted all the entries then you can Reorganize table online by brtools pls follow link http://help.sap.com/saphelp_nw70/helpdata/en/1b/4e8f0d38a8f4419436d608a36b6581/frameset.htm

    If table contains the LONG or RAW fields then refer note no 646681.

    This will free up the space and you can see it in %free space in DB02.

    also you can see the reduced table size

    3) If you want to reduce the Database size then you need to offline reorganize Tablespace by sapdba/brtools.

    Hope this is helpful

    Regads

    Umesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 11:31 AM

    Hi Jameel

    brtools -> 3 - Segment management -> 1 = Reorganize tables ->

    5 ~ Table owner (owner) ............ [SAPSID] <- could also be SAPR3/SAPSR3

    6 ~ Table names (table) ............ [ARFCSSTATE]

    Make sure:

    - you have a valid database backup

    - you tested the procedure on a non-productive system

    - you have read SAP Note 646681

    Best regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 04:28 AM

    Please be aware that when you are performing online reorganization of either the table or tablespace, sufficient space is available as a temporary container for the objects before they are moved to the new location. Its always a good practise to perform it during low activity on the system.

    Offline reorganization (export / import) does not need free space to be available at the DB level, but will need space at OS level to dump the table and also a downtime to complete the tasks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2007 at 09:37 AM

    .

    null

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2007 at 09:43 AM

    thanks mho

    thanks umesh and

    thanks baran

    thanks all

    i AM able to do that now

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.