| data_pump name_expr [message #465493] |
Wed, 14 July 2010 06:25  |
sanju_chenna
Messages: 5
Registered: June 2010
|
Junior Member |
|
|
HI,
I have name_expr in datapump import procedure,which has long list of tables.
I am storing those names in global temp table and trying to get values in name_expr as follow
DBMS_DATAPUMP.metadata_filter(handle => h1,NAME => 'NAME_EXPR',
VALUE => 'IN(SELECT OBJ_NM FROM ObjectsInfo_temp_table)',
object_type => 'TABLE');
**ObjectsInfo_temp_table is global temp table
i am getting error
ORA-31655: no data or metadata objects selected for job
when i try same thing with normal table it works ....am i missing somthing here..please help me
Sandhya
|
|
|
|
|
|
| Re: data_pump name_expr [message #465597 is a reply to message #465508] |
Wed, 14 July 2010 23:16  |
sanju_chenna
Messages: 5
Registered: June 2010
|
Junior Member |
|
|
HI Michel,
thanks for response.
I was trying tune my procedure as it is taking lot of time.
there is a select statement(with 4 joins) has to be executed 3 times for different reasons...i tried to keep those results in GTT and use them ....now as we can't use GTT ...can you please suggest any other method for tuning.
Sandhya
[Updated on: Wed, 14 July 2010 23:18] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: data_pump name_expr [message #465736 is a reply to message #465705] |
Thu, 15 July 2010 08:23 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:actually it took equal time not much difference
This does not surprised me, the main problem is on the query you use.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
.