perl Archives - DbaFix

Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl

By adminPosted on January 19, 2023

Question : What could be the best approach ? Till now could figure out the following (Oracle) Calling exp.exe and […]

By adminPosted on January 10, 2023

Question : I want to create an alphanumeric sequence like this: AAAA0000 AAAA0001 AAAA0002 AAAA0003 . . . AAAA9999 AAAB0000 […]

By adminPosted on October 21, 2022

Question : I am attempting to solve a problem explained in another question here. On Debian 7.4 with Postgres 9.1.12, […]

By adminPosted on October 18, 2022

Question : I think this boils down to “Am I doomed to upgrading mysql hoping the problem goes away?”. I’ve […]

By adminPosted on October 6, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

By adminPosted on September 25, 2022

Question : I had a PostgreSQL database with loads of scanned documents, as a document bytea column in the table […]

By adminPosted on July 5, 2022

Question : I’ve been trying to speed up a generic auditing trigger that I had written in pl/pgsql some time […]

By adminPosted on June 23, 2022

Question : How can I kill session with infinite looped plperl function? Both pg_terminate_backend and pg_cancel_backend had no effect. kill […]

By adminPosted on May 10, 2022

Question : As far as I can understand temp_buffers setting serve for storing temp tables data. But as I have […]

By adminPosted on May 6, 2022

Question : I am running a Perl script (using DBI) which reads from raw files from a hard disk, and […]