Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272

Category: databases

Digital solution partner

Oracle import/export schema via SQL script running a JOB.

tested on Oracle XE 10g to make a simple bk from Oracle you can use dbms library like: create or replace directory dumpdir as ‘/home/[youruserpath]/’ /* ESPORTA DATI E METADATI DI UNO SCHEMA */ declare handle number; begin handle :=‘EXPORT’,’SCHEMA’); dbms_datapump.add_file(handle,'[destination_file_name].dmp’,’DUMPDIR’); DBMS_DATAPUMP.add_file( handle => Handle, filename => ‘.log’, directory => ‘DUMPDIR’, filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE…
Read more

How to Restrict access to the phpMyAdmin by IP Address

Tested on Ubuntu 18.04 LTS

Interbase 2019

In this August Embarcadero announces the new version of the well-known Interbase report database: Interbase 2019. Interbase is widely used by Delphi developers since in the multi-platform environment (iOS, Android, Windows, Mac OSX, Linux) I believe it is the only relational database that can be distributed even on iOS / Android platforms, the inter-base versions…
Read more

Firebird Performance Tour 2019 – Prague

  Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Read more

Orace Tips – Recursive query

Firebird Sql Tips… Enable or Disable all trigger via sql

To enable and disable all triggers of a database i do two procedure : Enabling all database trigger:

Disabling all database trigger: