This is gonna sound silly but I can't seem to get my create tablespace to work. Never done one before. Says I need a datafile?
I'm using a virtual box for queries to mess around but I want to know how to create tablespace for my user newuser
i tried "create tablespace newspace" after granting myself the create tablespace priv.
I want to know how to do the default, and a basic non-default version of create tablespace please