Re: DBMS_METADATA in 10.2
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: gogala@xxxxxxxxxxxxx
- Date: Mon, 01 Aug 2005 20:28:33 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
