3 Replies Latest reply: Nov 30, 2012 2:07 AM by Niket Kumar RSS

    Impdp table only

      Hi, on Linux.

      I have expdp of 10 schemas which has all objects included.
      Now, I have to import those exported 10 schemas on a different database with tables and indexes only.



      Edited by: KSG on Nov 30, 2012 3:10 PM
        • 1. Re: Impdp table only
          Table Exports/Imports

          The TABLES parameter is used to specify the tables that are to be exported. The following is an example of the table export and import syntax.

          expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log
          impdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.logWhat objects don´t you watn to import?

          INCLUDE and EXCLUDE

          The INCLUDE and EXCLUDE parameters can be used to limit the export/import to specific objects. When the INCLUDE parameter is used, only those objects specified by it will be included in the export/import. When the EXCLUDE parameter is used, all objects except those specified by it will be included in the export/import. The two parameters are mutually exclusive, so use the parameter that requires the least entries to give you the result you require. The basic syntax for both parameters is the same.

          INCLUDE=object_type[:name_clause] [, ...]
          EXCLUDE=object_type[:name_clause] [, ...]
          The following code shows how they can be used as command line parameters.

          expdp scott/tiger@db10g schemas=SCOTT include=TABLE:"IN ('EMP', 'DEPT')" directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

          expdp scott/tiger@db10g schemas=SCOTT exclude=TABLE:"= 'BONUS'" directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log
          If the parameter is used from the command line, depending on your OS, the special characters in the clause may need to be escaped, as follows. Because of this, it is easier to use a parameter file.

          include=TABLE:\"IN (\'EMP\', \'DEPT\')\"
          A single import/export can include multiple references to the parameters, so to export tables, views and some packages we could use either of the following approaches.



          The valid object type paths that can be included or excluded can be displayed using the DATABASE_EXPORT_OBJECTS, SCHEMA_EXPORT_OBJECTS, and TABLE_EXPORT_OBJECTS views.

          What object´s don´t you want to include?

          Edited by: mschnatt on 30.11.2012 00:04
          • 2. Re: Impdp table only
            Use foll comand
            impdp dumpfile=DUMP_FILE_NAME.dmp logfile=LOG_FILE_NAME.log remap_schema=OLD_SCHEMA:NEW_SCHEMA directory=DIRECTOY_NAME
            • 3. Re: Impdp table only
              Niket Kumar
              impdp username/password include=table,index dumpfile etc.....