Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e7XmP-0006oc-Qw for pgsql-admin@arkaria.postgresql.org; Thu, 26 Oct 2017 02:20:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e7XmO-0005uG-Lp for pgsql-admin@arkaria.postgresql.org; Thu, 26 Oct 2017 02:20:20 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e7XkO-0002eg-Od for pgsql-admin@postgresql.org; Thu, 26 Oct 2017 02:18:16 +0000 Received: from mail-pf0-x229.google.com ([2607:f8b0:400e:c00::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e7XkL-0005Nq-By for pgsql-admin@postgresql.org; Thu, 26 Oct 2017 02:18:15 +0000 Received: by mail-pf0-x229.google.com with SMTP id 17so1371003pfn.12 for ; Wed, 25 Oct 2017 19:18:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=aY98uMTYwJ7rtvtCSk3IXA+j8lJ0qFk6nvRhktXJJ/U=; b=18zE9+iKRU9rDS7g8pwlIslJHJ8SDpdiDLa8dQEVuL7n2X+4XwY3zzlXTpnGespOJ6 qvVVs/8UTcwkjiJT2S72dbk3B9CdtFr/v1Mo5ieoyxH8XC83BjtjjzM8by6FtFq9r2CB dT1iRaDCK/W1aKyQ+6luPW5pNs/a/21PAmVx1zKwGzFAIsOwBX6ulQ70t12MC5WG2fBA duqdHV68KgP4etKDQtV+J0zQFigi9aqoeUQTfkpBNtmFqXAEMbZZf7gruMmzuc4OwzQO wzBOTwp6ciiId549KTU9Qr9MB/MWBhyYkXZ1DokGYk4psvuJvmaIIztY836grOaHqwLI cTeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=aY98uMTYwJ7rtvtCSk3IXA+j8lJ0qFk6nvRhktXJJ/U=; b=Jbme35BlDB/5JygMhqsuuvf5pw8U3elvBArQsvIpMLFeLLQoJXRc/mrQ+AdCJ2Aw1l kPRDqO2FaZU3bKWFlpk5QSdspFCeQZCWvDhySqymuBJj4Im1/F4/dL/WlqC+xGhbxfuh hDYsuoNP/yOPdm2VYKyw5GU5cmlfDf4TRvYXITqItgt2rKXUbX6zpipV+5KBbinPkN7C X+P8rpD8++wJzTbKKSO+ajd+gtrbxV3D1Weo/x//HsUy/wKblKZ9Z/0xKXHx8e5jiDL8 XiwmTP3P8JdKzSOqrEZUuBbNSQrm3ccW5UsMfrlNxL05kEpmA0M1yLnGr4RBfxj6XVGw qTxQ== X-Gm-Message-State: AMCzsaUPk93aShDl2rltc8rh9coYN6l/5vHYR3LHJKg3Yjf0tCesh9sS 7n7BKjw9hmALeUDBImoT5jhPkmTG5qAXZ2eWpBYDtQT8liuEIXTxG8s8hL1J6J8O8sIpK5vT8+P NaO1wYkOT8SLkOSyjdjOMvQRPYO3UNC7OuIPZtuYV+9kj1eCKRdK7ncnDl7d7Y+nxCi8NRiwbXJ 3HS2ZtoIQ= X-Google-Smtp-Source: ABhQp+QNRSeDK5kqf6oI7mMOj0bhxA3sTIQvcsb9ljCrgRjqpAOV6jJi0NrrgFXHNA4hSDLKqu7eBA== X-Received: by 10.101.80.6 with SMTP id f6mr3683430pgo.264.1508984291509; Wed, 25 Oct 2017 19:18:11 -0700 (PDT) Received: from osaka.octopusnet (p2388023-ipngn18001marunouchi.tokyo.ocn.ne.jp. [153.204.17.23]) by smtp.gmail.com with ESMTPSA id a70sm6919050pfa.94.2017.10.25.19.18.09 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 25 Oct 2017 19:18:10 -0700 (PDT) Subject: Re: Migrate from Oracle 12g to PostgreSQL 9.3 To: "Gust, Thorsten" , "pgsql-admin@postgresql.org" References: From: Ian Barwick Message-ID: <00091225-d643-1631-a1c3-e0cb64c9c9b5@2ndquadrant.com> Date: Thu, 26 Oct 2017 11:18:07 +0900 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 10/25/2017 10:19 PM, Gust, Thorsten wrote: > Hi All, > > I’m looking for a solution regarding migrate a user from Oracle DB to PostgreSQL > having the same permissions, Tablespace Quota, Table Privileges, Roles and so on > afterwards. > > Any help would be much appreciated!! Out of interest, any reason why you're targetting PostgreSQL 9.3? It's currently the oldest of the community-supported releases and will probably be EOL'd some time in late 2018 [*] [*] https://www.postgresql.org/support/versioning/ Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin