RE: Transportable Tablespace

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 14 Feb 2005 11:17:13 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C5D@irvmbxw02>

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

--
http://www.freelists.org/webpage/oracle-l

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