This discussion is archived
3 Replies Latest reply: Nov 30, 2012 12:07 AM by Niket Kumar RSS

Impdp table only

KSG Explorer
Currently Being Moderated
Hi,

10.2.0.4 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.

Solution: exclude=SEQUENCE,PROCEDURE,PACKAGE,TRIGGER,FUNCTION,SYNONYM,VIEW,TYPE (while doing impdp)

Thanks
KSG

Edited by: KSG on Nov 30, 2012 3:10 PM
  • 1. Re: Impdp table only
    761512 Newbie
    Currently Being Moderated
    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.

    INCLUDE=TABLE,VIEW,PACKAGE:"LIKE '%API'"

    or

    INCLUDE=TABLE
    INCLUDE=VIEW
    INCLUDE=PACKAGE:"LIKE '%API'"
    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
    Vedant.. Journeyer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    impdp username/password include=table,index dumpfile etc.....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points