Hi , thanks for the reply.

But my question is "previously i used dynamically generated tables(not temporary tables).Now i want to use temporary tables instead of using dynamically created tables.

In some situations i may need to join the temporary table with dblink tables.
So if i join temporary table with dblink will that cause the performance problem.
If yes, then how?