Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qg2TQ-00EDkN-QY for pgsql-general@arkaria.postgresql.org; Tue, 12 Sep 2023 12:26:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qg2TP-008KJf-Lg for pgsql-general@arkaria.postgresql.org; Tue, 12 Sep 2023 12:26:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qg2TP-008KJP-AJ for pgsql-general@lists.postgresql.org; Tue, 12 Sep 2023 12:26:31 +0000 Received: from ms-10.1blu.de ([178.254.4.101]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qg2TL-00497r-Jy for pgsql-general@lists.postgresql.org; Tue, 12 Sep 2023 12:26:29 +0000 Received: from [212.222.85.178] (helo=pureos) by ms-10.1blu.de with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95) (envelope-from ) id 1qg2TI-007cpR-Iv for pgsql-general@lists.postgresql.org; Tue, 12 Sep 2023 14:26:24 +0200 Date: Tue, 12 Sep 2023 14:26:23 +0200 From: Matthias Apitz To: pgsql-general@lists.postgresql.org Subject: Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? Message-ID: Reply-To: Matthias Apitz References: <20230912121919.zo74rbdhflpgp2eq@hjp.at> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20230912121919.zo74rbdhflpgp2eq@hjp.at> X-Operating-System: FreeBSD 13.0-CURRENT r368166 (amd64) X-message-flag: Mails containing HTML will not be read! Please send only plain text. X-Con-Id: 51246 X-Con-U: 0-guru X-Originating-IP: 212.222.85.178 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk El día martes, septiembre 12, 2023 a las 02:19:19 +0200, Peter J. Holzer escribió: > > - Or can we add additional parameters to the ora2pg.conf file to control this > > process and ensure that the data is imported sequentially, following the > > primary key from smallest to largest? AFAIK, a simple SELECT in PostgreSQL without an ORDER BY will return the rows in random order. matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub