Skip to Content
0
Former Member
Dec 01, 2008 at 12:01 PM

Reorgenization Problem

35 Views

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