7 Replies Latest reply on Dec 28, 2012 8:45 AM by leen

    unable to take export from particular tables from the schema.

    leen
      i created a schema duser data is imported and now i want to take select tables from this schema.
      the tables are (partyhdr,partyaddressdtl,partycontactdtl,partydsdtl,partytdsexcludedtl,partycurrencydtl)


      D:\>EXP DUSER/LOG@ORCL FILE=20121221PARTY0228PM.DMP TABLES=PARTYHDR,PARTYADDRESS
      DTL,PARTYCONTACTDTL,PARTYTDSDTL,PARTYTDSEXCLUDEDTL,PARTYCURRENCYDTL;

      Export: Release 10.1.0.2.0 - Production on Fri Dec 21 14:30:21 2012
      Copyright (c) 1982, 2004, Oracle. All rights reserved.
      Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
      Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
      About to export specified tables via Conventional Path ...
      . . exporting table PARTYHDR 19387 rows exported
      . . exporting table PARTYADDRESSDTL 20747 rows exported
      . . exporting table PARTYCONTACTDTL 226 rows exported
      . . exporting table PARTYTDSDTL 53 rows exported
      . . exporting table PARTYTDSEXCLUDEDTL 2 rows exported
      EXP-00011: DUSER.PARTYCURRENCYDTL; does not exist
      Export terminated successfully with warnings.

      as i check in schema partycurrencydtl table is their AND SHOWING RECORDS ALSO.

      SELECT OBJECT_TYPE FROM ALL_OBJECTS WHERE OWNER='DUSER'AND OBJECT_NAME='PARTYCURRENCYDTL';

      OBJECT_TYPE
      -------------------
      TABLE

      i am able understand why this particualr table is not exporting.

      Kindly help out.
        • 1. Re: unable to take export from particular tables from the schema.
          Fran
          EXP-00011: table does not exist
          http://oracletube.wordpress.com/2011/01/20/oracle-11gr2-exp-00011-occurs-even-object-exist-in-schema/

          check the status of the table.
          • 2. Re: unable to take export from particular tables from the schema.
            CloudDB
            D:\>EXP DUSER/LOG@ORCL FILE=20121221PARTY0228PM.DMP TABLES=PARTYHDR,PARTYADDRESS
            DTL,PARTYCONTACTDTL,PARTYTDSDTL,PARTYTDSEXCLUDEDTL,*PARTYCURRENCYDTL;*

            PARTYCURRENCYDTL;

            EXP-00011: DUSER.PARTYCURRENCYDTL; does not exist

            Edited by: hitgon on Dec 21, 2012 4:41 PM
            • 3. Re: unable to take export from particular tables from the schema.
              CloudDB
              Please use the below command without Semicolon

              EXP DUSER/LOG@ORCL FILE=20121221PARTY0228PM.DMP TABLES=PARTYHDR,PARTYADDRESS
              DTL,PARTYCONTACTDTL,PARTYTDSDTL,PARTYTDSEXCLUDEDTL,PARTYCURRENCYDTL
              • 4. Re: unable to take export from particular tables from the schema.
                Osama_Mustafa
                Refer to MOS
                Original Export Raises EXP-11 Table Does Not Exist or Table is Ignored [ID 960216.1]
                In 11gR2 Skips The Table At Full And Schema Level Export Or Shows EXP-00011 At Table Level Export [ID 1178343.1]
                • 5. Re: unable to take export from particular tables from the schema.
                  CloudDB
                  CASE-1

                  C:\>exp userid=scott/tiger file=c:/exp_scott_table.dmp tables=EMP,*DEPT;*

                  Export: Release 10.2.0.1.0 - Production on Fri Dec 21 17:00:58 2012

                  Copyright (c) 1982, 2005, Oracle. All rights reserved.


                  Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                  Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

                  About to export specified tables via Conventional Path ...
                  . . exporting table EMP 14 rows exported
                  EXP-00011: SCOTT.DEPT; does not exist
                  Export terminated successfully with warnings.

                  CASE-2

                  C:\>exp userid=scott/tiger file=c:/exp_scott_table.dmp tables=EMP,*DEPT*

                  Export: Release 10.2.0.1.0 - Production on Fri Dec 21 17:01:10 2012

                  Copyright (c) 1982, 2005, Oracle. All rights reserved.


                  Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                  Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

                  About to export specified tables via Conventional Path ...
                  . . exporting table EMP 14 rows exported
                  *. . exporting table DEPT 4 rows exported*
                  Export terminated successfully without warnings.

                  Edited by: hitgon on Dec 21, 2012 5:04 PM
                  • 6. Re: unable to take export from particular tables from the schema.
                    leen
                    THANK YOU,

                    D:\>EXP DUSER/LOG@ORCL FILE=20121221PARTY0228PM.DMP TABLES=PARTYHDR,PARTYADDRESS
                    DTL,PARTYCONTACTDTL,PARTYTDSDTL,PARTYTDSEXCLUDEDTL,PARTYCURRENCYDTL

                    Export: Release 10.1.0.2.0 - Production on Tue Jan 1 16:55:14 2013

                    Copyright (c) 1982, 2004, Oracle. All rights reserved.


                    Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
                    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

                    About to export specified tables via Conventional Path ...
                    . . exporting table PARTYHDR 19387 rows exported
                    . . exporting table PARTYADDRESSDTL 20747 rows exported
                    . . exporting table PARTYCONTACTDTL 226 rows exported
                    . . exporting table PARTYTDSDTL 53 rows exported
                    . . exporting table PARTYTDSEXCLUDEDTL 2 rows exported
                    . . exporting table PARTYCURRENCYDTL 429 rows exported
                    Export terminated successfully without warnings.

                    D:\>
                    • 7. Re: unable to take export from particular tables from the schema.
                      leen
                      Dear hitqon,

                      i am facing the below problem in export only,but their is no problem in import.

                      Tablespace Details

                      FILE-NAME TABLESPACE_NAME BYTES BLOCKS
                      D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\AXPERT.DBF AXPERT 8589934592 1048576

                      Version:

                      WE ARE USING version
                      Oracle Database 10g Release 10.1.0.2.0 - Production
                      PL/SQL Release 10.1.0.2.0 - Production
                      CORE     10.1.0.2.0     Production
                      TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
                      NLSRTL Version 10.1.0.2.0 - Production

                      D:\>EXP CENTRAL/LOG@ORCL FILE=20121217CENTRAL0857AMFROMSERVER237.DMP
                      Export: Release 10.1.0.2.0 - Production on Mon Dec 17 08:57:47 2012
                      Copyright (c) 1982, 2004, Oracle. All rights reserved.
                      Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
                      Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
                      About to export specified users ...
                      . exporting pre-schema procedural objects and actions
                      . exporting foreign function library names for user CENTRAL
                      . exporting PUBLIC type synonyms
                      . exporting private type synonyms
                      . exporting object type definitions for user CENTRAL
                      About to export CENTRAL's objects ...
                      . exporting database links
                      . exporting sequence numbers
                      . exporting cluster definitions
                      EXP-00056: ORACLE error 24324 encountered
                      ORA-24324: service handle not initialized
                      EXP-00056: ORACLE error 24324 encountered
                      ORA-24324: service handle not initialized
                      EXP-00000: Export terminated unsuccessfully

                      Only export will be successfully,when we restarted the oracle services. How to over come this issue with out restarting the oracle services.

                      Edited by: leen on Dec 28, 2012 12:43 AM