I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to load some data for development purposes. I am planning to create a new user and load the data under this new user's schema.
I would like to keep this data outside the SSD. I already have a mount point to an HDD inside the VM (as a network share). This mount point is a Samba share from another VM in the same machine.
My question is, how do I create a tablespace for the datafiles on this HDD mount point?
It would be nice if I can point undo and temporary tablespaces also to the HDD mount point.
My objective is to keep the VM size as low as possible.
I will appreciate if someone can point me in the right direction.