If this is in the wrong forum, please feel free to move it
I noticed today that my storage is at 100%
I went to the help...
Storage
This chart shows the total and used storage capacity of the service. It indicates what percentage of the space is currently in-use. The used storage capacity is the total allocated space for all tablespaces.
Here are my tablespaces...
The SAMPLESCHEMA tablespace is used by objects in the SH and SSB schemas
The SSB schema contains the tables: lineorder, customer, supplier, part, and dwdate. The following is a list of sample queries and analytic views you can use against the SSB schema. Note that you need to prefix the table names with the schema name SSB in your queries.
Note:
Both SH and SSB are provided as schema-only users, so you cannot unlock or drop those users or set a password. And the storage of the sample data sets does not count towards your database storage.
But mine isn't a Data Warehouse, is there a safe method for me to drop these schemas?
Can I just issue...
DROP USER SSB CASCADE;
DROP USER SH CASCADE;
Any help/advice greatly appreciated!