Reply from Reagan Benjamin on Aug 14 at 3:02 AM Hello I dont think it is possible to perform a reorg of the table TST03 using BRTools as the table TST03 has LONG or LONG RAW fields. You either need to convert long2lob or do an export/import. You can convert them in brtools under option - Segment management - Reorganize tables - Reorganization action (action) - long2lob. Another good option is: If you dont want to retain anything older than 10 days, then set the parameter to file system (G) and then restart the instance. After 10 days, or on the 11th day truncate the table TST03 from SQL and the switch the parameter back to DB during the next restart of the instance. Cheers RB
| | | ---------------Original Message--------------- From: Jaguar Sent: Monday, August 13, 2012 3:31 AM Subject: TST03 - Reorg Hi, We intend to re-org our TST03 table (Table size is about 200 GB) using the oracle export/import utility. This is how we have planned. 1) Change the parameter rspo/store_location to G. This parameter stores all the spools in the filesystem (sapmnt/SID/global 2) Allow the spool re-org jobs to clean-up TST03 (The oldest spool retention period is 10 days) 3) export the table - Truncate the table - import the table. 4) switch the parameter rspo/stor_location to db The filesystem /sapmnt/SID/global is an NFS mount in 4 servers. Would there be any issues in storing the spool requests in the filesystem. Our system generates about 47000 spool requests a day. As we are allowed to restart the SAP system only once a month, we'll have to store the spool requests in the filesystem for a month before we switch it back to the database. does anyone foresee any issues. Thanks for your time!! regards, | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |
No comments:
Post a Comment