Skip to Main Content

Database Software

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.

EXPDP utility Error: ORA-39166: Object DEPT; was not found

SadockJul 21 2011 — edited Jan 19 2012
Dear all

I am trying to export table by using EXPDP utility, but i am getting error: ORA-39166: Object DEPT; was not found

these ere the steps I am using:

Creating directory object and granting privileges to SCOTT

SQL> create directory dump_dir as 'd:\dump_files';
Directory created.

SQL> grant read, write on directory dump_dir to scott;
Grant succeeded.

then calling EXPDP to handel the job:

C:\Users\sadock>expdp scott/tiger directory=test_dir dumpfile=dept_table.dmp logfile=dept_log.log tables=dept;

Export: Release 11.1.0.6.0 - Production on Thursday, 21 July, 2011 14:05:55

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** directory=test_dir dumpfile=dept_table.dmp l
ogfile=dept_log.log tables=dept;
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object DEPT; was not found.
ORA-31655: no data or metadata objects selected for job
Job "SCOTT"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at 14:05:59

Justifying table DEPT exist in SCOTT schema

SQL> connect scott/tiger@orcl
Connected.
SQL> desc dept
Name Null? Type
----------------------------------------- -------- -------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)

I am wondering enough why it says Object DEPT; was not found while i can justify table exist. I am using Oracle 11gR1in W7
please anyone with help

Regards
Sadock

Comments

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

Post Details

Locked on Feb 16 2012
Added on Jul 21 2011
11 comments
8,341 views