Oracle – Popular Misconceptions: Tables without Segments

Perhaps some of you know the SAP note #825653 Oracle: Common errors in which Martin Frauendorfer collected many "myths" and all-time misconceptions about Oracle databases. Here's another one. "For all tables in an Oracle database, there is a segment in DBA_SEGMENTS." This is true for the vast majority of tables in an SAP installation, but … Continue reading Oracle – Popular Misconceptions: Tables without Segments

Questions to SAP Support: “How to generate a SQL Script via SQL on MaxDB?”

A customer was facing a problem when generating SQL scripts by using SQL. As this is a common habit in the Oracle world he tried to apply it to his MaxDB. The script in this specific case should drop views from a specified schema. Anyhow the same technique may be used to change the default sample … Continue reading Questions to SAP Support: “How to generate a SQL Script via SQL on MaxDB?”