No specific setup is needed for the Parquet-format file destination.
The following setup of the Postgres Pro destination is needed:
Install and enable the following extensions, available starting with Postgres Pro 16.4:
CREATE EXTENSION IF NOT EXISTS pgpro_bfile;
CREATE EXTENSION IF NOT EXISTS pgpro_sfile;
CREATE EXTENSION IF NOT EXISTS dbms_lob;
do
$$
BEGIN
PERFORM sf_initialize();
EXCEPTION WHEN OTHERS THEN
RAISE NOTICE 'already initialized';
end;
$$;
To migrate BFILE objects, create the same aliases as in the source DB:
do
$$
BEGIN
PERFORM bfile_directory_create('ALIAS1', '/tmp/alias1');
EXCEPTION WHEN OTHERS THEN
RAISE NOTICE 'alias1 already exists';
end;
$$;
do
$$
BEGIN
PERFORM bfile_directory_create('ALIAS2', '/tmp/alias2');
EXCEPTION WHEN OTHERS THEN
RAISE NOTICE 'alias2 already exists';
end;
$$;
Transfer the schema from the source DB using ora2pgpro.