RE: Transportable Tablespace
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <Meenakshi.Aggarwal@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Feb 2005 11:17:13 -0800
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;
*
ERREUR à la ligne 1 :
ORA-06550: Ligne 1, colonne 29 :
PLS-00103: Symbole ";" rencontré à la place d'un des symboles suivants :
(etc...)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
