Skip to Content
avatar image
Former Member

Reorgenization Problem

Dear Experts ,

I am facing some problem in reorgenization , I have gone through the sap note - 646681 . we are using mySAP ECC5 with Oracle 9.2.0.6 on windows 64 bit server .I am little bit confused in the below procedure

1.Server hard disk was full so I have added an USB hard disk .

2. I have to reorgenize PSAPDEV tablespace with LONG fields .

3. I have created one tablespace PSAPDEVD located on USB Hard disk.

4. Started the online reorgenization.I am using brtools to do it , so ddl script is automaticaly generated .

5. Stopped the SAP through MMC

5. after successful complition of online reorgenization I have started the offline reorgenization for LONG fields ,in the offline dump file path to USB Drive .

6. After succesffully completion of offline Export . I have dropped the original Table space PSAPDEV .

7. Now started the ddl.sql first script .

8. After first ddl.sql script I have started the import process .

9. After successfuly completiong of import Started the another two sql scripts .

10. Moved the tablespace from USB drive to Local Hard drive .

Q1. should I start reorgenization again for to remain the tablespace name orginal , because this time the tablespace name is PSAPDEVD and the original tablespace name was PSAPDEV .

Rename is not supported in Oracle 9.2.0.6 .

Q2. in present situation sap is started but giving dumps .

Q.3. Pl. advice me if I am wrong any where .

I am already in touch with Eric Brunelle (He has also given the great support to me ).

Pl. help me

Thanks

Neeraj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 01, 2008 at 01:02 PM

    Hi Neeraj,

    Please check below point as per note 646681.

    1. Creating a new target tablespace

    brspace -f tscreate -t <new_tsp> -s <size> -a yes -m <max_size>

    -i <incr_size> -l {all <old_tsp>} Make sure that the new tablespace is large enough to enter all tables.

    If necessary, extend the tablespace with additional files or use

    Auto-Extend.

    brspace -f tsextend -t <new_tsp> -s <size> -a yes -m <max_size>

    -i <incr_size>

    Caution: Do not forget to set the " -l" option (table data class), so

    that the new tablespaces copy all standard SAP data classes. If you

    only want to move all tables from one or several (but not all)

    tablespace[s] into a new tablespace, instead of "all", set the name[s]

    of the old tablespace[s] in the "-l" option: "-l

    <old_tsp_name>[,<old_tsp_name>,...]". The new tablespace thus copies the

    data types assigned to the old tablespace[s]. However, if you only want

    to move individual tables into a new tablespace, do not set this option.

    As a result, BRSPACE automatically generates a new data class that is

    assigned to the individual tables during the reorganization.

    I have question for you while creating PSAPDEVD tablespace have you used the above option.

    How you have created tablespace? can you provide that command?

    As per the above statement in note if you use -l option while creating tablespace it shd assign data class to new tablesapce automatically.

    Can you tell us what short dumps you are getting?

    Good Luck,

    Atil

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2008 at 01:31 PM

    you should continue posting on your original topic and not open a new one.

    thanks.

    Add comment
    10|10000 characters needed characters exceeded