[Maria-discuss] Encryption

2016-05-16 Thread Ghazi Btissam
Hi, -Oracle has the tablespace feature ,does MariaDb has the same feature ? -If yes how MariaDb encrypt a tablespace ? Thanks ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://la

[Maria-discuss] MariaDB coding questions

2016-04-26 Thread Ghazi Btissam
Hi, - As the Oracle package does'nt exist, how MariaDB structure its code ? - Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? Thanks ___ Mailing list: https://launch

[Maria-discuss] MariaDb Questions

2016-04-18 Thread Ghazi Btissam
Hi , I have a lot of questions about MariaDb if you can help please: - - Comment on effectue le purge d’une table volumineuse (question partitionning à cause de ses contraintes) ? - - - How the purge is done under MariaDB for volumineous tables (as the partitionning has a big constraint: no

[Maria-discuss] MariaDb tablespaces?

2016-04-18 Thread Ghazi Btissam
Hi, Is there tablespace in MariaDb like Oracle?if yes which storage engine use them and how? Thanks ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss

[Maria-discuss] MariaDb Entreprise edition (ColumnStore)

2016-04-17 Thread Ghazi Btissam
Hi, 1- Is MariaDb Enterprise open source software (and all its components and modules? 2- Regarding the Spider engine: the feature allows 2 spider tables from different servers to share each of them partitions from a master spider which hold those partitions? please give some explainations Thank

[Maria-discuss] Partitionning question

2016-03-14 Thread Ghazi Btissam
Hi, 1- Could a partitioned table contain, or be referenced by, foreign keys? 2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST? Thanks

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2

2016-03-14 Thread Ghazi Btissam
Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the *update *of the remote data is it possible? Thanks __

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2

2016-03-12 Thread Ghazi Btissam
Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the update of the remote data is it possible? Thanks ___ M

[Maria-discuss] AUTO_INCREMENT and partitioning

2016-03-12 Thread Ghazi Btissam
Hi, 1- I have a table with a unique key which is calculated by the AUTO_INCREMENT feature, and I need to range partition it using a date field , is it possible and/or how to do it? 2- Is there a way to implement sequences for the primary key (like it exists in Oracle) or the AUTO_INCREMENT is the

[Maria-discuss] Read/Write file

2016-03-12 Thread Ghazi Btissam
Hi, How to read/write a text file from a MariaDb routine ? Is this possible only via tables (loading via Load data infile or using connect engine..)? Thanks ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchp