oracle create tablespace error,创建TABLESPACE 的ORA-03214错误

本文展示了如何使用Oracle的ALTER SYSTEM DUMP DATAFILE命令来转储指定数据文件的具体块内容。通过四个不同的块转储操作,揭示了数据文件中包含的不同类型的元数据结构,如文件空间头部、位图和第一级位图块。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

SQL> alter system dump datafile 63 block 1;

System altered.

SQL> alter system dump datafile 63 block 2;

System altered.

SQL> alter system dump datafile 63 block 3;

System altered.

SQL> alter system dump datafile 63 block 4;

System altered.

*** 2011-08-24 22:46:04.332

*** ACTION NAME:() 2011-08-24 22:46:04.155

*** MODULE NAME:(sqlplus@sjfdcdb9 (TNS V1-V3)) 2011-08-24 22:46:04.155

*** SERVICE NAME:(SYS$USERS) 2011-08-24 22:46:04.155

*** SESSION ID:(269.1439) 2011-08-24 22:46:04.155

Start dump data blocks tsn: 17 file#: 63 minblk 1 maxblk 1

Block 1 (file header) not dumped: use dump file header command

End dump data blocks tsn: 17 file#: 63 minblk 2 maxblk 1

*** 2011-08-24 22:51:55.105

Start dump data blocks tsn: 17 file#: 63 minblk 2 maxblk 2

buffer tsn: 17 rdba: 0x0fc00002 (63/2)

scn: 0x0000.3e20db7a seq: 0x03 flg: 0x04 tail: 0xdb7a1d03

frmt: 0x02 chkval: 0x2ecc type: 0x1d=KTFB Bitmapped File Space Header

Hex dump of block: st=0, typ_found=1

Dump of memory from 0xB5E53E00 to 0xB5E55E00

B5E53E00 0000021D 0FC00002 3E20DB7A 04030000  [........z. >....]

B5E53E10 00002ECC 0000003F 00000080 00000183  [....?...........]

B5E53E20 00000009 00000100 00000580 00000002  [................]

B5E53E30 00000183 00000002 00000001 00000000  [................]

B5E53E40 00000000 00000000 00000000 00000000  [................]

B5E53E50 00000084 00000080 00000000 00000000  [................]

B5E53E60 00000000 00000000 00000000 00000000  [................]

Repeat 504 times

B5E55DF0 00000000 00000000 00000000 DB7A1D03  [..............z.]

File Space Header Block:

Header Control:

RelFno: 63, Unit: 128, Size: 387, Flag: 9

AutoExtend: YES, Increment: 256, MaxSize: 1408

Initial Area: 2, Tail: 387, First: 2, Free: 1

Deallocation scn: 0.0

Header Opcode:

Save: No Pending Op

End dump data blocks tsn: 17 file#: 63 minblk 2 maxblk 2

Start dump data blocks tsn: 17 file#: 63 minblk 3 maxblk 3

buffer tsn: 17 rdba: 0x0fc00003 (63/3)

scn: 0x0000.3e20db7a seq: 0x01 flg: 0x04 tail: 0xdb7a1e01

frmt: 0x02 chkval: 0xde39 type: 0x1e=KTFB Bitmapped File Space Bitmap

Hex dump of block: st=0, typ_found=1

Dump of memory from 0xB5E53E00 to 0xB5E55E00

B5E53E00 0000021E 0FC00003 3E20DB7A 04010000  [........z. >....]

B5E53E10 0000DE39 0000003F 00000004 00000000  [9...?...........]

B5E53E20 00000002 0000F7FE 00000000 00000000  [................]

.。。。。

Start dump data blocks tsn: 17 file#: 63 minblk 4 maxblk 4

buffer tsn: 17 rdba: 0x0fc00004 (63/4)

scn: 0x0000.3e20dbdd seq: 0x03 flg: 0x04 tail: 0xdbdd2003

frmt: 0x02 chkval: 0x1786 type: 0x20=FIRST LEVEL BITMAP BLOCK  (这里type和前3个是不一样的了)

Hex dump of block: st=0, typ_found=1

Dump of memory from 0xB5E53E00 to 0xB5E55E00

B5E53E00 00000220 0FC00004 3E20DBDD 04030000  [ ......... >....]

B5E53E10 00001786 00000000 00000000 00000000  [................]

B5E53E20 00000000 00000000 00000000 00000000  [................]

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值