| Restrict DBMS_METADATA.GET_XML output [message #184730] |
Thu, 27 July 2006 10:31 |
claref
Messages: 2
Registered: July 2006
|
Junior Member |
|
|
Hi,
I'm just started using DBMS_METADATA to get object metadata from the DB in XML format (GET_XML). Is there a way of restricting the amount of information that is returned by the GET_XML command. For example I don't want the SEGMENT_ATTRIBUTES or STORAGE information to get returned. Setting the SET_TRANSFORM_PARAM, STORAGE parameter to false works for the GET_DDL command but not for the GET_XML comand. The following is an example of the information returned by GET_XML of a simple 5 column table. Any ideas on reducing the information returned?
<?xml version="1.0"?><ROWSET><ROW> <TABLE_T>
<VERS_MAJOR>1</VERS_MAJOR>
<VERS_MINOR>1 </VERS_MINOR>
<OBJ_NUM>13638</OBJ_NUM>
<SCHEMA_OBJ>
<OBJ_NUM>13638</OBJ_NUM>
<DATAOBJ_NUM>13638</DATAOBJ_NUM>
<OWNER_NUM>36</OWNER_NUM>
<OWNER_NAME>VIRTUO</OWNER_NAME>
<NAME>LC_LOADMAP</NAME>
<NAMESPACE>1</NAMESPACE>
<TYPE_NUM>2</TYPE_NUM>
<TYPE_NAME>TABLE</TYPE_NAME>
<CTIME>2006-07-24 13:23:15</CTIME>
<MTIME>2006-07-24 13:23:15</MTIME>
<STIME>2006-07-24 13:23:15</STIME>
<STATUS>1</STATUS> <FLAGS>0</FLAGS> <SPARE1>6</SPARE1> <SPARE2>1</SPARE2> </SCHEMA_OBJ> <STORAGE> <FILE_NUM>4</FILE_NUM> <BLOCK_NUM>211</BLOCK_NUM> <TYPE_NUM>5</TYPE_NUM> <TS_NUM>4</TS_NUM> <BLOCKS>8</BLOCKS> <EXTENTS>1</EXTENTS> <INIEXTS>8</INIEXTS> <MINEXTS>1</MINEXTS> <MAXEXTS>2147483645</MAXEXTS> <EXTSIZE>128</EXTSIZE> <EXTPCT>0</EXTPCT> <USER_NUM>36</USER_NUM> <LISTS>1</LISTS> <GROUPS>1</GROUPS> <BITMAPRANGES>0</BITMAPRANGES> <CACHEHINT>0</CACHEHINT> <SCANHINT>0</SCANHINT> <HWMINCR>13638</HWMINCR> <FLAGS>131329</FLAGS> </STORAGE> <TS_NAME>USERS</TS_NAME> <BLOCKSIZE>8192</BLOCKSIZE> <DATAOBJ_NUM>13638</DATAOBJ_NUM> <COLS>7</COLS> <PCT_FREE>10</PCT_FREE> <PCT_USED>40</PCT_USED> <INITRANS>1</INITRANS> <MAXTRANS>255</MAXTRANS> <FLAGS>1073741825</FLAGS> <AUDIT_VAL>--------------------------------------</AUDIT_VAL>
<INTCOLS>7</INTCOLS> <KERNELCOLS>7</KERNELCOLS> <PROPERTY>536870912</PROPERTY> <XMLSCHEMACOLS>N</XMLSCHEMACOLS> <TRIGFLAG>0</TRIGFLAG> <SPARE1>736</SPARE1> <SPARE6>24-JUL-06</SPARE6>
<COL_LIST>
<COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>1</COL_NUM> <INTCOL_NUM>1</INTCOL_NUM> <SEGCOL_NUM>1</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>RULESET_ID</NAME> <TYPE_NUM>2</TYPE_NUM> <LENGTH>22</LENGTH> <PRECISION_NUM>5</PRECISION_NUM> <SCALE>0</SCALE> <NOT_NULL>0</NOT_NULL> <CHARSETID>0</CHARSETID> <CHARSETFORM>0</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>0</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>2</COL_NUM> <INTCOL_NUM>2</INTCOL_NUM> <SEGCOL_NUM>2</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>BLOCKNAME</NAME> <TYPE_NUM>1</TYPE_NUM> <LENGTH>100</LENGTH> <NOT_NULL>0</NOT_NULL> <CHARSETID>178</CHARSETID> <CHARSETFORM>1</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>100</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>3</COL_NUM> <INTCOL_NUM>3</INTCOL_NUM> <SEGCOL_NUM>3</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>TABNAME</NAME> <TYPE_NUM>1</TYPE_NUM> <LENGTH>128</LENGTH> <NOT_NULL>0</NOT_NULL> <CHARSETID>178</CHARSETID> <CHARSETFORM>1</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>128</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>4</COL_NUM> <INTCOL_NUM>4</INTCOL_NUM> <SEGCOL_NUM>4</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>COLNAME</NAME> <TYPE_NUM>1</TYPE_NUM> <LENGTH>128</LENGTH> <NOT_NULL>0</NOT_NULL> <CHARSETID>178</CHARSETID> <CHARSETFORM>1</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>128</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>5</COL_NUM> <INTCOL_NUM>5</INTCOL_NUM> <SEGCOL_NUM>5</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>COLTYPE</NAME> <TYPE_NUM>1</TYPE_NUM> <LENGTH>5</LENGTH> <NOT_NULL>0</NOT_NULL> <CHARSETID>178</CHARSETID> <CHARSETFORM>1</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>5</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>6</COL_NUM> <INTCOL_NUM>6</INTCOL_NUM> <SEGCOL_NUM>6</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>COLORDER</NAME> <TYPE_NUM>2</TYPE_NUM> <LENGTH>22</LENGTH> <PRECISION_NUM>5</PRECISION_NUM> <SCALE>0</SCALE> <NOT_NULL>0</NOT_NULL> <CHARSETID>0</CHARSETID> <CHARSETFORM>0</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>0</SPARE3> </COL_LIST_ITEM> <COL_LIST_ITEM> <OBJ_NUM>13638</OBJ_NUM> <COL_NUM>7</COL_NUM> <INTCOL_NUM>7</INTCOL_NUM> <SEGCOL_NUM>7</SEGCOL_NUM> <PROPERTY>0</PROPERTY> <NAME>UPDATE_FLAG</NAME> <TYPE_NUM>2</TYPE_NUM> <LENGTH>22</LENGTH> <PRECISION_NUM>5</PRECISION_NUM> <SCALE>0</SCALE> <NOT_NULL>0</NOT_NULL> <CHARSETID>0</CHARSETID> <CHARSETFORM>0</CHARSETFORM> <SPARE1>0</SPARE1> <SPARE2>0</SPARE2> <SPARE3>0</SPARE3> </COL_LIST_ITEM> </COL_LIST> <CON0_LIST/> <CON1_LIST/> <CON2_LIST/> </TABLE_T> </ROW></ROWSET>
Any ideas?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
