Note234724.1 How do I dump the datafile of locally managed temporary tablespace

alter system dump tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1

dump 信息如下：

*** SERVICE NAME:(SYS$USERS) 2009-01-20 14:31:49.169

*** SESSION ID:(138.5) 2009-01-20 14:31:49.169

Memory Notification: Library Cache Object loaded into SGA

Heap size 2249K exceeds notification threshold (2048K)

LIBRARY OBJECT HANDLE: handle=6c853778 mutex=6C85382C(0)

name=XDB.XDbD/PLZ01TcHgNAgAIIegtw==

hash=e0f82b0c545a707da230a62675d34c80 timestamp=08-30-2005 14:28:09

namespace=XDBS flags=KGHP/TIM/SML/[02000000]

kkkk-dddd-llll=0000-0000-0000 lock=S pin=S latch#=2 hpc=0002 hlc=0002

lwt=6C8537D4[6C8537D4,6C8537D4] ltm=6C8537DC[6C8537DC,6C8537DC]

pwt=6C8537B8[6C8537B8,6C8537B8] ptm=6C8537C0[6C8537C0,6C8537C0]

ref=6C8537F4[6C8537F4,6C8537F4] lnd=6C853800[6C853800,6C853800]

  LIBRARY OBJECT: bject=6a1cc854

  type=XDBS flags=EXS/LOC[0005] pflags=[0000] status=VALD load=X

  DATA BLOCKS:

  data#     heap  pointer    status pins change whr alloc(K)  size(K)

  ----- -------- -------- --------- ---- ------ --- -------- --------

      0 6c9ce2ec 6a1cc910 I/P/A/-/-    0 NONE   00      0.34     0.00

      1 6a1cc94c 6a1538b4 I/P/A/-/-    1 NONE   00   2249.43  2269.51

不能使用alter system dump datafile ,否则会出现如下的错误：

alter system dump datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1

ERROR at line 1:

   ORA-01205: not a data file - type number in header is 6