Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .
Wednesday, 7 September 2011
Query returns a list of tablespaces that contain XMLTypes:
select distinct p.tablespace_name from dba_tablespaces p,
dba_xml_tables x, dba_users u, all_all_tables t where
t.table_name=x.table_name and t.tablespace_name=p.tablespace_name
No comments:
Post a Comment