Re: create unique tablename?

PC (pc_at_wellington.mafqual.govt.nz) wrote:

: i need to create a unique tablename, do some inserts and drop it from a sql
: script.
 

: is there an easy way without doing this type of thing:
 

: spool create_table.sql
: select 'create table '||'some unique string' etc etc;
: spool off
: _at_create_table.sql
 

: the script will be running from a cron job at anytime and all users
: who run it will be logging on to oracle under the same userid.

A pretty standard thing to try is to include the System Date, including the hours, minutes, and milliseconds, into the table name. This scenerio works for situations where multiple users are not concurrently trying to do this. (In other words, you won't get two users with the same number for milliseconds in the System Date.)  

Kent Siemers
Database Administration, University Information Systems The University of Michigan Received on Tue Oct 11 1994 - 19:38:55 CET