OraFAQ Forum: Server Utilities » Parfile expdp problem

Home » RDBMS Server » Server Utilities » Parfile expdp problem (Oracle 11g 11.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Parfile expdp problem [message #679709]

Wed, 18 March 2020 08:45

fmonjes
Messages: 10
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

Report message to a moderator

Re: Parfile expdp problem [message #679711 is a reply to message #679709]

Wed, 18 March 2020 08:50

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Parfile expdp problem [message #679729 is a reply to message #679711]

Thu, 19 March 2020 17:34

fmonjes
Messages: 10
Registered: February 2020

Junior Member

I have answered the previous topic ....

Report message to a moderator

Re: Parfile expdp problem [message #679730 is a reply to message #679729]

Fri, 20 March 2020 01:27

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Parfile expdp problem [message #679759 is a reply to message #679730]

Mon, 23 March 2020 17:27

fmonjes
Messages: 10
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"')

Report message to a moderator

Re: Parfile expdp problem [message #679760 is a reply to message #679709]

Mon, 23 March 2020 17:28

fmonjes
Messages: 10
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:07:07 CST 2025