Skip to content

Content Tagged "schema"

Page 1 of 1

Content Tagged "schema"

Postgres: Show Schema Sizes in a Database

October 2, 2014Category: Software
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: Which results in a list like: ] HTH, PS: All credit goes to this StackOverflow answer !

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

April 1, 2014Category: Software
An important note when loading XSDs in Oracle is that DBMS XMLSCHEMA.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…

Drop an Oracle-Loaded XSD in Python

March 31, 2014Category: Software
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: You can use it if e.g. schema is updated or we don't need it anymore. The…

All tags