Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

plsql tool export tables gives weird log file

kiran_oracleJul 20 2016 — edited Jul 20 2016

Hi

I have few tables in  db  where   i am taking  export  of tables from plsql developer.

so , i  started,

tools--> export tables---> select all  tables

                                -----> user name

                                 -----> export  path  and then  finally  export.

during the process,  a log  file  catch is done in the  exporting  window.

when i  open  it, for some reason ,  Though  i have all the  tables in the database ,it  returns  'table does not  exist'  .But i have all those tables in  db;

EXP-00011: user_1.XX2 does not exist

EXP-00011: user_1.XX3 does not exist

EXP-00011: user_1.XX4 does not exist

EXP-00011: user_1.XX5 does not exist

EXP-00011: user_1.XX6 does not exist

EXP-00011: user_1.XX7 does not exist

EXP-00011: user_1.ZZZ does not exist

here  is  the  catch  of the  export  log  file. May  i  know  what  might  be the  reason  for this weird  behavior?

Please help me on this  issue.

-------------------------------------------------------------------------------------------

Export started on 20-07-2016 4:52:29 PM

F:\Oracle_k_home\product\11.2.0\dbhome_1\BIN\exp.exe parfile=C:\Users\KIRAN_~1\AppData\Local\Temp\plsexp.par

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

Note: grants on tables/views/sequences/roles will not be exported

Note: indexes on tables will not be exported

About to export specified tables via Conventional Path ...

. . exporting table              ALL_TABLES_ROWCNT          0 rows exported

. . exporting table                             BB         38 rows exported

. . exporting table                          CAKES         13 rows exported

. . exporting table                         COFFEE         14 rows exported

. . exporting table                            DDD          1 rows exported

. . exporting table          DELETED_TABLE_HISTORY          1 rows exported

. . exporting table                   DEPARTMENTS1          4 rows exported

. . exporting table                         DRINKS          5 rows exported

. . exporting table                       EATABLES          5 rows exported

. . exporting table                            EMP          1 rows exported

EXP-00064: EMP_ADDRS_DTLS_TAB is an inner nested table and cannot be exported.

. . exporting table                    EMP_DETAILS          1 rows exported

. . exporting table             EMP_ADDRS_DTLS_TAB          1 rows exported

. . exporting table           EMP_FULLNAME_DETAILS          1 rows exported

. . exporting table              EMP_OTHR_DTLS_TAB          0 rows exported

. . exporting table             EMP_PHONE_DTLS_TAB          0 rows exported

. . exporting table       EMP_PRMNT_ADDRD_DTLS_TAB          0 rows exported

EXP-00064: EMP_FULLNAME_DETAILS is an inner nested table and cannot be exported.

EXP-00064: EMP_OTHR_DTLS_TAB is an inner nested table and cannot be exported.

EXP-00064: EMP_PHONE_DTLS_TAB is an inner nested table and cannot be exported.

EXP-00064: EMP_PRMNT_ADDRD_DTLS_TAB is an inner nested table and cannot be exported.

. . exporting table                       EMP_TEMP          2 rows exported

. . exporting table                         FRUITS          8 rows exported

. . exporting table                    ITEM_MASTER          3 rows exported

. . exporting table          K_GET_TAB_CONSTRAINTS          2 rows exported

. . exporting table             K_USER_DEL_OBJECTS         18 rows exported

. . exporting table                           MSTR         39 rows exported

. . exporting table               MULTI_DATA_TYPES          3 rows exported

EXP-00011: user_1.PLSQL_PROFILER_DATA does not exist

EXP-00011: user_1.PLSQL_PROFILER_RUNS does not exist

EXP-00011: user_1.PLSQL_PROFILER_UNITS does not exist

EXP-00011: user_1.PQ does not exist

EXP-00011: user_1.SAMP_1 does not exist

. . exporting table                   SYS_TEMP_FBT

. . exporting table                        TABLE_1

. . exporting table                      TBLGENDER          4 rows exported

. . exporting table                      TBLPERSON         14 rows exported

. . exporting table                            TEA          6 rows exported

EXP-00011: user_1.TEA_COFFEE does not exist

. . exporting table                          TEMP1         50 rows exported

EXP-00011: user_1.TEMP2 does not exist

. . exporting table                           TEST         18 rows exported

. . exporting table             TRACK_USER_INSERTS          6 rows exported

. . exporting table                     VEGETABLES         22 rows exported

EXP-00011: user_1.X does not exist

. . exporting table                             XX          7 rows exported

. . exporting table                            XX1         15 rows exported

EXP-00011: user_1.XX2 does not exist

EXP-00011: user_1.XX3 does not exist

EXP-00011: user_1.XX4 does not exist

EXP-00011: user_1.XX5 does not exist

EXP-00011: user_1.XX6 does not exist

EXP-00011: user_1.XX7 does not exist

EXP-00011: user_1.ZZZ does not exist

Export terminated successfully with warnings.

Export finished on 20-07-2016 4:53:36 PM

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 17 2016
Added on Jul 20 2016
0 comments
196 views