3 Replies Latest reply on Jul 23, 2019 12:16 PM by EdStevens

    Datapump question

    2817831

      Hi All

       

      We are taking full expdp dump and importing full dump in another database . I just need to know does it import sys schema when you run full=y in impdp command

       

      What happens to sys schema objects during import does it import the sys object from source or it skips completely sys schema

       

       

      Thanks

      Suresh

        • 1. Re: Datapump question
          EdStevens

          2817831 wrote:

           

          Hi All

           

          We are taking full expdp dump and importing full dump in another database . I just need to know does it import sys schema when you run full=y in impdp command

           

          What happens to sys schema objects during import does it import the sys object from source or it skips completely sys schema

           

           

          Thanks

          Suresh

          From the docs (https://docs.oracle.com/database/121/SUTIL/GUID-BA07401C-6261-4B07-AD2C-06CD0A6E0BE9.htm#SUTIL851 )

           

           

          FULL

          Default: NO

          Purpose

          Specifies that you want to perform a full database mode export.

          Syntax and Description

           

          FULL=[YES | NO] 

          FULL=YES indicates that all data and metadata are to be exported. To perform a full export, you must have the DATAPUMP_EXP_FULL_DATABASE role.

          Filtering can restrict what is exported using this export mode. See "Filtering During Export Operations".

          You can perform a full mode export using the transportable option (TRANSPORTABLE=ALWAYS). This is referred to as a full transportable export, which exports all objects and data necessary to create a complete copy of the database. See "Using the Transportable Option During Full Mode Exports".

          Note:

          Be aware that when you later import a dump file that was created by a full-mode export, the import operation attempts to copy the password for the SYS account from the source database. This sometimes fails (for example, if the password is in a shared password file). If it does fail, then after the import completes, you must set the password for the SYS account at the target database to a password of your choice.

           

          Restrictions

          • To use the FULL parameter in conjunction with TRANSPORTABLE (a full transportable export), either the Data Pump VERSION parameter must be set to at least 12.0. or the COMPATIBLE database initialization parameter must be set to at least 12.0 or later.
          • A full export does not, by default, export system schemas that contain Oracle-managed data and metadata. Examples of system schemas that are not exported by default include SYS, ORDSYS, and MDSYS.
          • 2. Re: Datapump question
            2817831

            Hi

             

            Could you please advise when we import the data via impdp through full=y does it import sys objects or not

             

            Note: We have taken full=y during expdp

             

            Thanks

            • 3. Re: Datapump question
              EdStevens

              2817831 wrote:

               

              Hi

               

              Could you please advise when we import the data via impdp through full=y does it import sys objects or not

               

              Note: We have taken full=y during expdp

               

              Thanks

              We see from the previously cited documentation that the SYS schema is not exported.

              So given that, how would you expect the import to import something was wasn't exported?