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