Re: DBMS_METADATA in 10.2

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 01 Aug 2005 20:28:33 -0600
Message-Id: <6.2.3.4.2.20050801202551.0417bb80@pop.centrexcc.com>

No problem with that sql on my 10.2 database:

20:21:32 orcl.scott> var patt varchar2(100) 20:24:37 orcl.scott> exec :patt := 'TEST%';

PL/SQL procedure successfully completed.

20:25:00 orcl.scott> select
dbms_metadata.get_ddl('TABLESPACE',tablespace_name) SQL

20:25:01   2        from dba_tablespaces
20:25:01   3        where tablespace_name !='SYSTEM'
20:25:01   4        and tablespace_name like upper(:PATT)
20:25:01   5        order by contents,tablespace_name
20:25:02   6  /

SQL

---

   CREATE TABLESPACE "TEST_8K_ASSM" DATAFILE    '/u01/oracle/product/10.2.0/oradata/orcl/test_8k_assm.dbf' SIZE 10485760    AUTOEXTEND ON NEXT 10485760 MAXSIZE 419430400    LOGGING ONLINE PERMANENT BLOCKSIZE 8192    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 65536 SEGMENT SPACE MANAGEMENT AUTO     ALTER DATABASE DATAFILE
   '/u01/oracle/product/10.2.0/oradata/orcl/test_8k_assm.dbf' RESIZE 419430400

No peep or trace in the alert log.
Are you sure you are running it on a supported platform ;-)

At 04:34 PM 8/1/2005, Mladen Gogala wrote:

>select dbms_metadata.get_ddl('TABLESPACE',tablespace_name) SQL


>       from dba_tablespaces

>       where tablespace_name !='SYSTEM'

>       and tablespace_name like upper(:PATT)

>       order by contents,tablespace_name


Regards

Wolfgang Breitling

Centrex Consulting Corporation
http://www.centrexcc.com

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

Received on Mon Aug 01 2005 - 21:29:17 CDT