RE: create tablespace script

[Fink, Dan]

Title: create tablespace script

DBA_DATA_FILES contains the tablespace name. Use that to 'group' the datafiles together.

-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Subject: create tablespace script

Hi!

I want to write a "create tablespace" script that creates all "create tablespace" statements for a database.

I got this script working if each tablesspace has only one datafile. But how would I handle it if a tablespace consists of 2 datafiles, e.g. datafile 5 and 87 from dba_data_files...

Is there an id for the datafiles within the tablespace???

Any ideas?

Thanks,
Helmut