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 -- //www.freelists.org/webpage/oracle-l