EXPDP utility Error: ORA-39166: Object DEPT; was not found
SadockJul 21 2011 — edited Jan 19 2012Dear 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