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 1qZDI2-004cqU-Hn for pgsql-general@arkaria.postgresql.org; Thu, 24 Aug 2023 16:34:35 +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 1qZDI1-00AqlG-3Z for pgsql-general@arkaria.postgresql.org; Thu, 24 Aug 2023 16:34:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZDI0-00Aql8-Jr for pgsql-general@lists.postgresql.org; Thu, 24 Aug 2023 16:34:32 +0000 Received: from mout-u-107.mailbox.org ([80.241.59.207]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZDHx-000oSa-Ht for pgsql-general@lists.postgresql.org; Thu, 24 Aug 2023 16:34:31 +0000 Received: from smtp202.mailbox.org (smtp202.mailbox.org [10.196.197.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4RWpZT6h0yz9sRy; Thu, 24 Aug 2023 18:34:25 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001; t=1692894866; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=RLvY5q0ebkiCEELcjRhBFPNfk4E5z25zfHu+5Zl+vW0=; b=1lBjYZg2BTo7fKbTcJd4yobsf2FQuRgE96sXsPFsPk4AoXaBiPfTIRi8Kv0DpTAmFj2f+S d0YiO02OZpZQ9B//aDK715KOTQ9Qiy5SAEcSCpqoBSWArZ666kZIsvtIP+/9PO08Upj2uc cuWVseC2folmy2L/SQtgY+HY4QYxfwKXgUQxbdC4vmexXz7CS055jDZFmN2kMLxzJr6CVD nA+mJb7nK/XPI9gRxcyyh992dJtzmDNBRpbH3surZoYpdH/1yef6eCG4sFSdopSI2ShNCp 1NQvg3LYI2UwYrNvMnJnB+vOUN9qnsW6/QIBE5dxQMsDL14y2w4UM2F0KZjJkA== Date: Thu, 24 Aug 2023 18:34:25 +0200 (CEST) From: Erik Wienhold To: duc hiep ha Cc: pgsql-general@lists.postgresql.org Message-ID: <899791304.435903.1692894865198@office.mailbox.org> In-Reply-To: References: Subject: Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 24/08/2023 15:49 CEST duc hiep ha wrote: > > Further updated to the below Post. Shortly question: > * Saving data to file using the following Command is fine: > ora2pg -c ora2pg.conf -t COPY -o data.sql schema/data/ > * Direct copy data from Oracle to Postgres doesn't work > (command: ora2pg -c ora2pg.conf -t COPY -a tablename). > Everything Else works fine. Connection to Oracle and Postgres using > DBD::Pg, DBD::Oracle are set correctly. Can you access table "tablename" when connecting with Postgres via psql and the connection settings from ora2pg.conf? Maybe privileges are missing or the table is not on the search path. -- Erik