Home » RDBMS Server » Server Utilities » unable to do partial export in linux (oracle 11.2.0.1.0)
unable to do partial export in linux [message #558194] Wed, 20 June 2012 02:50 Go to next message
kesavansundaram
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'; 

   COUNT(*)
----------
      2378

> 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 11.2.0.1.0 - 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 11.2.0.1.0 - 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-39166: Object UET_REP.EPM_CUSTOMERDISPOSITIONS was not found.
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
cookiemonster
Messages: 13917
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: Fri Mar 29 00:37:41 CDT 2024