OraFAQ Forum: Server Utilities » INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work

Home » RDBMS Server » Server Utilities » INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work (RDBMS 11.2.0.2 RHEL6)

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

INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522849]

Wed, 14 September 2011 04:05

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

I get this when trying the expdp:


ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job

There are data in the TT table. Is the include badly formatted?

Regards

Report message to a moderator

Re: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522852 is a reply to message #522849]

Wed, 14 September 2011 04:20

cookiemonster
Messages: 9290
Registered: September 2008
Location: Rainy Manchester

Senior Member

I see nothing in the documentation to say you can use a query inside the include. Though I also see nothing to say you can't.
What happens if you replace the query with

SELECT table_name FROM user_tables

Report message to a moderator

Re: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522856 is a reply to message #522852]

Wed, 14 September 2011 04:45

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

I found it on metalink: 315529.1

Your suggestion gave the same error.

[Updated on: Wed, 14 September 2011 04:45]

Report message to a moderator

Re: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522862 is a reply to message #522856]

Wed, 14 September 2011 05:05

cookiemonster
Messages: 9290
Registered: September 2008
Location: Rainy Manchester

Senior Member

In that case you probably need to talk to oracle support.

Report message to a moderator

Re: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522946 is a reply to message #522862]

Wed, 14 September 2011 12:38

hristo
Messages: 258
Registered: May 2007

Senior Member

The problem is that you cant do it like that when using partitions.

Problem when I use a parameter file is:

I got two errors:

First there where two many rows in the file. I then shorted the file and I then got that I needed "," between each table.

The parameter file looks like this, the interesting part:

TABLES=ldw.table1:part1,
ldw.table1:part2,
...
and so on.
(we created a script to get all the partitions, thats why then end up one table:partition on each row)

For some reason, EXPDP dont understand the "," and a new line is the same as the same line.

I guess the EXPDP expects this:

TABLES=ldw.table1:part1,ldw.table1:part2,...

But we have over 1800 partitions. And changing this manually is insane.

Does any one have an idea?

Regards
H

Report message to a moderator

Re: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522947 is a reply to message #522946]

Wed, 14 September 2011 12:44

BlackSwan
Messages: 20245
Registered: January 2009

Senior Member

>But we have over 1800 partitions. And changing this manually is insane.
place everything but username/password in control file.
use SQL to create majority of the content of control file using SPOOL or UTL_FILE

Report message to a moderator

Previous Topic:	Data Pump
Next Topic:	expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 19:39:21 CDT 2013

Total time taken to generate the page: 0.14949 seconds