Re: Unique spool filenames?

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/05/02
Message-ID: <336A0567.1A58@ebmud.com>#1/1

You could use DBMS_SESSION.UNIQUE_SESSION_ID to get a value that is unique to the session that is running. If you have multiple spool files in a single session that need to be unique, you could create a sequence to get a guaranteed unique number to suffix to the file name. These approaches are generic and usable in any environment that supports long filenames, not just Unix.

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect

| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com

+-----------------------------------------------------

Mike Moritz wrote:
>
> Is there a way within SQLPlus to create unique filenames for spool
> files. In unix one can use 'filename.$$' which will append the
> process ID. Can I do something similar from SQLPlus, running under
> unix?
>
> Thanks
> --
> __ __ _ _
> | \/ |(_)| |__ ___ __o
> | |\/| || || / // -_) Mike Moritz _ \<._
> |_| |_||_||_\_\\___| mmoritz_at_netcom.com ____(_)/ (_)____
Received on Fri May 02 1997 - 00:00:00 CDT