Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_METADATA in 10.2
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 01 2005 - 21:29:17 CDT