Oracle Database Discussions

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!

Unable to export a table

504289Nov 5 2008 — edited Nov 5 2008

Hi,

I am trying to export a table using Datapump export utility but the operation is failing. Firstly, this is the table I am trying to export:

*****
SQL> select owner, table_name from dba_tables where table_name='DEMO1';

OWNER TABLE_NAME
------------------------------ ------------------------------
SYS DEMO1

SQL> select * from DEMO1;

ID
----------
1
2
3
*****

This is how the expdp command is run:

*****
$ expdp DUMPFILE=demo1.dmp TABLES=DEMO1

Export: Release 11.1.0.6.0 - Production on Wednesday, 05 November, 2008 12:37:28

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

Username: sys as sysdba
Password:

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 "SYS"."SYS_EXPORT_TABLE_01": sys/******** AS SYSDBA DUMPFILE=demo1.dmp TABLES=DEMO1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object DEMO1 was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at 12:37:37
*****

I have searched for the error ORA-39166 but most of the results talk about either missing table or lack of privileges. I don't think either is the cause of the problem here. Any help is appreciated.

Thanks,
Raghu