Transportable tablespace 2005-02-14 - By Jacques Kilchoer
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 (See ORA-06550.ora-code.com): 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
--
http://www.freelists.org/webpage/oracle-l
|
|
