Posted by: Khurram Naseem
Date: November 15, 2014 03:12AM


According to documentation , one can define Tablespace in create table clause and also you can define data_directory and log_directory, and we can also define directory for tablespace in create tablesapce.

for e.g if I've created tablespace TS1 with define directory /home/xyz/mysqldata and create table T1 with data directory /home/abc/mysqldata. Which directory will take precedence ?

Thank you

Options: ReplyQuote

Written By
November 15, 2014 03:12AM
November 16, 2014 12:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.