Database Utilities (MOSC)

MOSC Banner

Need help in expdp query

edited Jun 21, 2018 11:25AM in Database Utilities (MOSC) 19 commentsAnswered ✓

SQL> show user

USER is "APPS"

SQL> grant select,insert,update on fnd_concurrent_requests to system;

Grant succeeded.

SQL>

expdp system/manager directory=test dumpfile=tes.dmp logfile=exp.log tables=apps.fnd_concurrent_requests query=fnd_concurrent_requests:"phase_code\=\'C'"

Export: Release 11.2.0.3.0 - Production on Tue Jun 9 12:00:39 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39034: Table FND_CONCURRENT_REQUESTS does not exist.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center