When someone creates a table in your 'abc' database it should by default
be in '/my/preferred/directory/_tablename_'. However, users can specify
locations for their tables which may not be in that directory. AFAIK
there's no way to prevent that.
Alan.
Chen Song <mailto:chen.song...@gmail.com>
April 2, 2015 at 8:15
I have a dumb question on DDL statement "create database"
Say if I create a database
|CREATE| |DATABASE| abc
|LOCATION||'/my/preferred/directory'||;|
When later on someone needs to create a table in this database, is
there a way to force the location of the table to be under
/my/preferred/directory?
I searched around but could not find a way to enforce this.
--
Chen Song
