https://wiki.plecko.hr/ 2026-04-09T22:33:27+00:00 https://wiki.plecko.hr/ https://wiki.plecko.hr/lib/tpl/bootstrap3/images/favicon.ico text/html 2019-10-31T09:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.plecko.hr/doku.php?id=database:oracle:indexes&rev=1572509040&do=diff Manually create indexes CREATE UNIQUE INDEX ix_inv_manufacturers_id ON "inv_manufacturers"("id") TABLESPACE INV_IDX; CREATE UNIQUE INDEX ix_inv_persons_id ON "inv_persons"("id") TABLESPACE INV_IDX; CREATE UNIQUE INDEX ix_inv_racks_id ON "inv_racks"("id") TABLESPACE INV_IDX; CREATE UNIQUE INDEX ix_inv_rooms_id ON "inv_rooms"("id") TABLESPACE INV_IDX; CREATE UNIQUE INDEX ix_inv_devices_iid ON "inv_devices"("iid") TABLESPACE INV_IDX; text/html 2019-10-31T09:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.plecko.hr/doku.php?id=database:oracle:start&rev=1572509040&do=diff Oracle * Install Ora8 on Ubuntu 16.04 to use with Apache2 and PHP7 * Manually create indexes text/html 2019-10-31T09:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.plecko.hr/doku.php?id=database:oracle:ubuntu_php7_apache2&rev=1572509040&do=diff Install Ora8 on Ubuntu 16.04 to use with Apache2 and PHP7 Don't mind the version numbers apt-get install php-pear php-dev build-essential unzip libaio1 Download oracle instant client basic and SDK and unzip them mkdir /opt/oracle unzip instantclient-basic-linux.x64-12.2.0.1.0.zip /opt/oracle unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip /opt/oracle/instantclient_12_2 chown -R root:www-data /opt/oracle cd /opt/oracle mv instantclient_12_2 instantclient cd instantclient echo /opt/oracle/…