Transportable Tablespace

From: Aggarwal, Meenakshi <Meenakshi.Aggarwal_at_fishersci.com>
Date: Mon, 14 Feb 2005 14:12:21 -0500
Message-ID: <32729C17301C744582A747BD41569C12017CB3F6@PGHCR-EXMB-VS-1.na.fshrnet.com>

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

Received on Mon Feb 14 2005 - 14:15:11 CST