Steve, I've been an SAP DBA for many moons so I'll try to field your questions. As you have alluded to, using SAPDBA for tablespace creation is a good idea since it also update the TSORA table with the tablespace name. It may also do other subtle things. And SAPDBA does a reasonable job managing CBO stats.
As far as the default tablespace goes. If you are controlling the deleting and recreating of the table, you can control the destination tablespace in Tx SE14 => Storage Parameters. If the tables are being automatically dropped and recreated in the "wrong" tablespace, the solution is more complicated but sound. 1) In development, modified the TAORA table to include a new record (data class) for each new tablespace, and dependent tables DDART & DARTT; 2) transport these changes; 3) in development, change the data class for these tables via TX se11 => technical settings and transport. This should change the default tablespace to the home-grown one. If you need (or want) more details, let me know. Caveat: We never got past 2) as too few tables were affected to warrent changing SAP-owned objects. Mike Hand Polaroid Corp -----Original Message----- Jared, I recently started a job that uses SAP on Oracle 8.1.7 and the only word that describes my day is "frustration". Are there any SAP do's and don'ts you can recommend? >From my brief experience, I should use SAPDBA to add tablespaces or check stats. Other than that I use sqlplus/scripts for everything else. When the system does have performance problems, it's really tough to isolate the problem because there's 400 users sharing 100+ connections and they're all SAPR3. the other irritating problem is on the BW system, tables get dropped and recreated in the wrong tablespace. I know there has to be screen (or table) that maps objects to tablespaces, but haven't found it. Any tips you have would be appreciated. Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
