2

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.

  • What sort of network share is it? SMB/NFS/vbox? – Philᵀᴹ Apr 30 '19 at 7:44
  • It is a Samba share from another VM in the same machine. I have updated the question with this detail. – unubar Apr 30 '19 at 12:59
  • You can't create Oracle data files on SMB mounts, I'm afraid. Best way of doing it would be to add a new virtual disk to the Oracle VM, with the virtual disk files (vmdk, or whatever) on the other HDD. – Philᵀᴹ Apr 30 '19 at 13:16
  • Thanks for the suggestion. Given this, I am thinking that instead of creating a new tablespace, why not move the existing tablespace/datafiles to the new vmdk. Looks like I can use the instructions in this article: link Would like to know what you think of this approach. Btw, this is a development machine so optimizing for performance is not necessary. But, I will have data for multiple projects on it -- which is the reason I want to keep the data on the HDD. – unubar Apr 30 '19 at 21:39
0

NFS

I highly recommend you change your design to use a supported file system : NFS.

The database can use its own NFS client driver (Direct NFS) to talk to the NFS Server. It will use the OS's if it can't use DNFS.

UNDO/TEMP

I'd keep these on the SSD and set AUTO EXTEND to NO.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.