SAP default tablespace (WAS: RE: Misinformation Ranting)

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-----
From: Steve Perry [mailto:sperry_at_sprynet.com] 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 Received on Wed Sep 11 2002 - 13:31:15 CDT