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!

plsql tool export tables gives weird log file

kiran_oracleJul 20 2016 — edited Jul 20 2016

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2016

Added on Jul 20 2016

0 comments

241 views