Transportable tablespace 2005-02-14 - By Aggarwal, Meenakshi
Hi!
I want to generate a list of tablespaces in the format 'TS1,TS2, TS3,
TS4,.....,TS200' As there are close to 200 or more tablespaces or so.
I am writing a query and based on the result set I need the o/p in the
form of comma separated tablespace names.
The below command works only if the tablespaces are in the same line.
exec dbms_tts.transport_set_check('TS1,TS2, TS3, TS4, ................ ,
TS200',true) ;=20
Somehow it doesn't work if the TS are in different lines.
exec dbms_tts.transport_set_check('TS1,
TS2,=20
TS3,=20
TS4,=20
................,
true) ;=20
How do I generated the above command thru a SQL Query if I need the
tablespaces in the same horizontal line. Since I need to put this is a
script and the tablespace names change based on month, so I can't
hardcode the Tablespace names.
Thanks
--
http://www.freelists.org/webpage/oracle-l
|
|
