Home » RDBMS Server » Server Utilities » Parfile expdp problem (Oracle 11g 11.2.0.1.0)
Parfile expdp problem [message #679709] Wed, 18 March 2020 08:45 Go to next message
fmonjes
Messages: 8
Registered: February 2020
Junior Member
Hi

I have a problem with the expdp parfile utility specifically, I have the following configuration:

DIRECTORY = DUMP
DUMPFILE = PW_RECHAZO.dmp
CLUSTER = n
LOGFILE = PW_RECHAZO.log
TABLES = PORTAL.PW_RECHAZO
CONTENT = data_only
QUERY = "where STATISTICALID in (select pwe.ISTATISTICALID from portalenex.pw_statistics pwe where pwe.rec_cant = 1)"

and it indicates the following error

UDE-00014: invalid value for parameter, 'query'.

It is a simple query and it was validated and works fine from terminal.

Now doing tests I realized that the length of the field "ID_ESTADISTICA" was the problem, I came to that conclusion because

run the following

DIRECTORY = DUMP
DUMPFILE = PW_RECHAZO.dmp
CLUSTER = n
LOGFILE = PW_RECHAZO.log
TABLES = PORTAL.PW_RECHAZO
CONTENT = data_only
QUERY = "where ID_EMISOR in (select pwe.EM_ID from portalenex.pw_estadistica pwe where pwe.rec_cant = 1)"

The truth is I don't know why the STATISTICAL ID field indicates error and the other shorter field without error. Did there exist any limit parameters regarding queries in parfile?

they are all numeric type fields in the Database

Thanks
Re: Parfile expdp problem [message #679711 is a reply to message #679709] Wed, 18 March 2020 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 67157
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe I could help but I am blocked waiting for your feedback in your previous topic.

Re: Parfile expdp problem [message #679729 is a reply to message #679711] Thu, 19 March 2020 17:34 Go to previous messageGo to next message
fmonjes
Messages: 8
Registered: February 2020
Junior Member
I have answered the previous topic ....
Re: Parfile expdp problem [message #679730 is a reply to message #679729] Fri, 20 March 2020 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 67157
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You must show us (copy and paste) what you do NOT tell us what you think you do.

For instance:

Quote:
I realized that the length of the field "ID_ESTADISTICA" was the problem

But "ID_ESTADISTICA" is NOT in what you posted.

Before posting, Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Re: Parfile expdp problem [message #679759 is a reply to message #679730] Mon, 23 March 2020 17:27 Go to previous messageGo to next message
fmonjes
Messages: 8
Registered: February 2020
Junior Member
Thanks for the answers, I could solve it like this:

DUMPFILE="PW_RECHAZO.dmp"
LOGFILE="PW_RECHAZO.log"
DIRECTORY=DUMP
CONTENT=data_only
QUERY=PORTAL.PW_RECHAZO:"where ID_ESTADISTICA IN (SELECT PWE.id_estadistica FROM PORTAL.PW_ESTADISTICA PWE WHERE PWE.EST_FECHA>=TO_DATE('01.01.2019','dd.mm.yyyy'))"
TABLES=('PORTAL."PW_RECHAZO"')
Re: Parfile expdp problem [message #679760 is a reply to message #679709] Mon, 23 March 2020 17:28 Go to previous message
fmonjes
Messages: 8
Registered: February 2020
Junior Member
...

[Updated on: Mon, 23 March 2020 17:28]

Report message to a moderator

Previous Topic: Disable Oracle Feature
Next Topic: Oracle 12c expdp using external table when it should be using direct
Goto Forum:
  


Current Time: Fri Jun 05 06:59:50 CDT 2020