Home » RDBMS Server » Server Utilities » unable to do partial export in linux (oracle
unable to do partial export in linux [message #558194] Wed, 20 June 2012 02:50 Go to next message
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
gettign error while try to take partial export :

select count(*) from uet_rep.epm_customerdispositions where datecreated > '1336626000'; 


> expdp uet_rep/uet_rep dumpfile=dods_export.dmp logfile=dods_export.log directory=KES_DIR tables='"""EPM_CUSTOMERDISPOSITIONS"""' query='"where datecreated > '1336626000'"' exclude=statistics

Export: Release - Production on Wed Jun 20 03:42:19 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "UET_REP"."SYS_EXPORT_TABLE_01":  uet_rep/******** dumpfile=dods_export.dmp logfile=dods_export.log directory=KES_DIR tables="""EPM_CUSTOMERDISPOSITIONS""" query="where datecreated > 1336626000" exclude=statistics
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-31655: no data or metadata objects selected for job

pls guie me
Re: unable to do partial export in linux [message #558253 is a reply to message #558194] Wed, 20 June 2012 07:03 Go to previous message
Messages: 13923
Registered: September 2008
Location: Rainy Manchester
Senior Member
It says the object doesn't exist.
What type of object is it?
What user does it belong to?
Previous Topic: What could be the fastest way to unload the data from oracle to text file.
Next Topic: impdp and database open mode (split from Moving from one Windows environment to another Linux environment)
Goto Forum:

Current Time: Tue May 21 13:52:22 CDT 2024