Re: Multiple Tablespaces with single mount point?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Fri, Aug 12, 2016 at 4:59 PM, Curious Tech <cutech777@xxxxxxxxx> wrote:

Hello,

I want to know what is the general practice when only one mount point is available. 

1. Use default tablespace

2. Use Default + User Define one tablespace

3. Use Default + User Defined Data + User Defined Index tablespaces

1.

Using non-default tablespace adds backup/restore complications.  Don't do that without a demonstrable benefit.  You will not be able to demonstrate a benefit when you only have a single filesystem.

David J.