schema - Laur's blog

Sign in Subscribe

schema

A collection of 3 posts

Postgres: Show Schema Sizes in a Database

Postgres: Show Schema Sizes in a Database

While loading a large database from files to a Postgres schema, I found very useful to know how much space on disk it actually occupies (just in case I need to re-size the disk). I found this answer online: SELECT schema_name, pg_size_pretty(sum(table_size)::bigint) as

Use Oracle's RegisterSchema with Large Schemas (from Python)

Use Oracle's RegisterSchema with Large Schemas (from Python)

An important note when loading XSDs in Oracle is that DBMSXMLSCHEMA.registerSchema() requires the actual content of the _xsd is loaded in a string. A side effect is that strings in Oracle have limits and schemas can exceed those limits. Therefore, such strings must be fragmented. In this case, we

Drop an Oracle-Loaded XSD in Python

Drop an Oracle-Loaded XSD in Python

A loaded schema can be dropped if: * No other schema depends on it * No data using the schema is loaded I think you may force unloading schemas even if there is data loaded but I haven't tried that. The code to drop a schema is: dbms_xmlschema.deleteSchema(