How to get a unique system-generated name for temporary table?

[Queyon]

I remember there is a function to get a unique system-generated name for temporary table but don't know how.
Please let me know if someone knows.

Thanks.

Queyon

[jhmartin]

Use a sequence as part of the name?

What is the requirements for this? Would a Global Temporary Table work better?

[Queyon]

I want to create a global temporary table but don't want to get any table name confict.

[LKBrwn_DBA]

You could also use a timestamp:

Create Table MyTempTable_<YYMMDDHH24MISS>... 

[marist89]

I want to create a global temporary table but don't want to get any table name confict.

Why in the world would you want to go through the overhead of creating a temporary table when you can just use a GTT?

[Telco_DBA]

I want to create a global temporary table but don't want to get any table name confict.

Read this very interesting article - it answers your question:

http://www.indiana.edu/~dss/Services...s/tmptabl.html

[tamilselvan]

I want to create a global temporary table but don't want to get any table name confict.

Do you know how GTT operates in Oracle?

Tamil

[marist89]

Do you know how GTT operates in Oracle?

Tamil

have to agree with that. trying to shoehorn somebody else's database on oracle. sometimes square pegs just don't fit into round holes no matter how big the hammer.

[jhmartin]

You could also use a timestamp:

Create Table MyTempTable_<YYMMDDHH24MISS>... 

Hopefully nobody will attempt to do that operation twice in a second...

[DaPi]

I want to create a global temporary table but don't want to get any table name confict.

If you create a GTT you only do it once and and any name conflict you'd resolve then. GTT avoids the need to create a name dynamically.