Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Transportable Tablespace
If you are trying to generate a script to run in SQL*Plus, the SQL*Plus continuation character is a "-" (minus sign).
SQL> execute dbms_output.put_line ('Hello')
Hello
Procédure PL/SQL terminée avec succès.
SQL> execute dmbs_output.put_line (
BEGIN dmbs_output.put_line (; END;
*
SQL> execute dbms_output.put_line ( -
> 'Hello' -
> )
Hello
Procédure PL/SQL terminée avec succès.
SQL>
-----Original Message-----
Aggarwal, Meenakshi
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 14 2005 - 14:20:11 CST