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 :: 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: 13966
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: 13966
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: 26766
Registered: January 2009
Location: SoCal

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

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

Fri, 12 July 2013 15:33

rajamanukonda
Messages: 1
Registered: July 2013

Junior Member

Use FULL=Y along with include while exporting.

Report message to a moderator

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

Wed, 07 August 2013 06:08

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

possibility of error reason would be the less mount point and yet to be increased, can you type in the full command-line..,statements what all you have used?

Report message to a moderator

Previous Topic:	impdp in linux ..help in this
Next Topic:	"Message 2100 not found" Errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:18:09 CST 2025