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 1uo8lE-00GsDa-4e for pgsql-admin@arkaria.postgresql.org; Mon, 18 Aug 2025 22:55:29 +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 1uo8lD-0031dN-IV for pgsql-admin@arkaria.postgresql.org; Mon, 18 Aug 2025 22:55:28 +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 1uo8lD-0031dE-7J for pgsql-admin@lists.postgresql.org; Mon, 18 Aug 2025 22:55:27 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uo8lB-000aww-24 for pgsql-admin@lists.postgresql.org; Mon, 18 Aug 2025 22:55:27 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-55ce526ac04so4414100e87.2 for ; Mon, 18 Aug 2025 15:55:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755557724; x=1756162524; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=tqc2yKBCpZFvd+OnkXPLgBHHCGcTuxLEo1bA/6Hp6Aw=; b=XK98T64ZUEWI4SMhdktFirnCDz0PXz5VGXmznufKmQ/zyjeVfm1Wr+NUySek7e0YnQ DozWXizIovc2qauCLFLBPBDoQCHKsKxh/B8vb3itXPRvDoAr21L+7UfbL1XXZdOQKyNu W1emUrYIfy04c8gmrXXPGgymaKNhVKaOk/Ri3AkaMtYbtABHPss78ZeBYQjbxm3De/A+ OWZbEW2B/OlmpXjIMdrp5wUfAFibG1Pj0/3EwP5mle0UUy5WtnjW7hhlBfRzgJaHtFus 0x/cfPOMOmzYRn4+hsr6XYyVT4AvRveIzo1BqjeaHVftMJXqd6FbgeysnqnMbUDOvvMP eyuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755557724; x=1756162524; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=tqc2yKBCpZFvd+OnkXPLgBHHCGcTuxLEo1bA/6Hp6Aw=; b=cZPBQq3phRmXvaM1I886k++lLhzd5wrL78eL40BGWltOEDK5TLQgqOh1w370K5AmVe cF2+uN1ledxLRnyVwMeAuYnDas7nekc0wHYnShRde1/OXkkQJMh/63SyVmvG5Lmp+oh1 4X75+k4pw+i58rUlR+U6ugwgKdbsFaFGiPwFFPADWF8m98JtEY/pguxXfgpIeO6bx7U+ ++ZlAPFtrWzOYZvLNP3f0G+tm0kMUpzhPMCI8ZWF+JVxtpPwK/+3locUT6wVFBzRIRM9 y5MdBuSdVjL3yyfxe3LLZnlXyZoE2Gi3Ak6X3hIw12j99AIh3GhcZ6GGy0jE81s+iQmi Fkdw== X-Gm-Message-State: AOJu0YxNz9mb/eNDg5PjyCmhu/VQoN7rtZfZaVgKi6PR26wTBmGZdqB5 ED14gItqJxu9Ic7rPEUwq33LWgFNVIR+zbKGGmpIxNI/5/+dwHwhQIMAzA+GcoJLNj6P9rIqSBE ouaT32qwwI0SWY8uRtelghQLStbbdByvw1A== X-Gm-Gg: ASbGncsEa5zTdRlvhUpUXK42QKw0okl+CjMy/6LZoWEEEc9ben3MoENH7gn6VCrlqm8 cJrKwr19z4ZkLERTrBz7WWuBvcycOVsCqoMzKKTub9DLF2Dkp+4g+O5VnOGVIFzhfn/f+Mul8Gu Gq/U5mGq4zYElNKolVpsA/QSSsanXmGvTxMbNnHUBCkxlo4FigNT4pD2gocfYnHZYFV7VB8vWYh 7H4lfaE X-Google-Smtp-Source: AGHT+IEZCbSQelYh9kAnWX7WkaeRilbrJoucOB9X4GB/OKPpMVUN6cFvseR0/4UlaQ3O0yfeNuNuB+5ZgwKSLpjMpZQ= X-Received: by 2002:a05:651c:2125:b0:330:d1e8:78c9 with SMTP id 38308e7fff4ca-3353080a97emr871881fa.37.1755557724313; Mon, 18 Aug 2025 15:55:24 -0700 (PDT) MIME-Version: 1.0 From: Raj Date: Tue, 19 Aug 2025 04:25:12 +0530 X-Gm-Features: Ac12FXzcglCXAI2ZXuFGQp1ccdEu0UYFh14pmPtqEF-Jr18tj8FO2GLCRJMvVoU Message-ID: Subject: Sequence of objects to import - Ora2pg To: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000008a5c13063caba28f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008a5c13063caba28f Content-Type: text/plain; charset="UTF-8" Hello All, What's the sequence of objects to be imported while using Ora2pg v25 (oracle 18c to postgres 17.x) so that I don't get error and conflict between parents and child tables etc. Should I start with this order sequences, sequence_values, Table, Indexes Views Procedures, function, triggers and finally grants --0000000000008a5c13063caba28f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello All,

W= hat's the sequence of objects to be imported while using Ora2pg v25 (or= acle 18c to postgres 17.x) so that I don't get error and conflict betwe= en parents and child tables etc.


Should I start with this order sequen= ces, sequence_values,
Table,=C2=A0
Indexes=C2=A0
Views
Pro= cedures, function, triggers and finally grants

<= /div>



--0000000000008a5c13063caba28f--