I have a tablespace that is of size 500mb. There isn't much data in my db so im unsure why its giving me this error message when I try to create a table in this tablespace.
I'd like to know if I can find out why it has filled up so quickly and how I can increase its size.
Also, as a temporary workaround I've built two tables in the otif_index tablespace. can I switch the tablespaces easily?