Home » RDBMS Server » Server Utilities » INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work (RDBMS 11.2.0.2 RHEL6)
INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work [message #522849] Wed, 14 September 2011 04:05 Go to next message
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
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
In that case you probably need to talk to oracle support.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
rajamanukonda
Messages: 1
Registered: July 2013
Junior Member
Use FULL=Y along with include while exporting.
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 Go to previous message
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?
Previous Topic: impdp in linux ..help in this
Next Topic: "Message 2100 not found" Errors
Goto Forum:
  


Current Time: Thu Mar 28 07:42:54 CDT 2024