FreeLists / oracle-l / Re: DBMS_METADATA in 10.2

[Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>]

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