March 2007 Archives

有趣的特殊字符

转自 http://www.830308.com/blog/article.asp?id=149

(一)规则形状(圆形、三角形、方形、菱形)
○ ⊙ ◎ ◐ ◑ 。 。 。° º o O . · ۰ • ● ◕ ◕ ☉⊕ Θ ✪ ✪ 
◣◢ ◤◥ ⊿ 
・ ‧ ▫ ▪ □ ▣ ▓ ▒ ░ ▧ ▨ ▤ ▥ ▦ ▩ ◘ ◙ ☒ ■ ▬ 〓 ▀ ▁ ▂ ▃ ▄ ▅ ▆ ▇ █ ▋▌▍▐ ◦ ◊ ♢ ♦
 ❖ ◇ ◈ ◆    
 
(二)图形符号
♂ ♀ ♠ ♣ ♥ ♦ ♤ ♡ ◇ ♧ ❤ ❥ ☜ ☞ ☎ ☏ ♨ ☺ ☻ ﹡ * ¤ ☼ ☀ ☽ ☾ ☆ ★ ☄ ☁ ☂ ✚ ✟ ✙ ✣ 
✤ ✥ ✦ ✧ ✩ ✫ ✬ ✭ ✮ ✯ ✰ ✪ ☆ ★ ❂ ❁ ❀ ✿ ✱ ✲ ✳ ❃ ✾ ✽ ✼ ✻ ✺ ✹ ✸ ✷ ✶ ✵ ✴ ❄ ❅ 
❆ ❇ ❈ ❉ ❊ ❋ ✱ ☸ ❣ ❦ ❧ ✁ ✄ ☪ ☣ ☢ ☠ ☭ ❣ ♈ ☮ ✈ ✡ ✓ ✔ √ ☑ ☒ ✗ ✘ ㄨ ✕ ✖ ✖ ✎ 
✏ ✐ ✌ ✍ ✉ ↂ ☯ ♛ ♕ ﹎  ₪ ¡ Þ ௫ ღ ☃  - 〝〞 ஐ ๑   ﻬ  L ☊ ☋ ♋ ☌ ☍ Ξ ぷ ∞≡ o'.'o ☃ ☹   〠 〄 ♝ ♞ ♟ ₪ ¤ 큐 〒 ⁂ ァ  γ ︿ しノж ю Ю  乀 ◖◗ Ш  ☃  ๑ ۩ ۞  ˇ и ண இ ஆ   
 
(三)标点符号 
︻ ︼ ︽ ︾  ︿ ﹀  ﹁ ﹂ ﹃ ﹄﹝﹞  「」 ︵ ︶ ︷ ︸ ︹ ︺ 【】〖〗《 》 « » 〔〕﹙﹚(){}
﹛﹜『』 ﹤﹥〈〉<> ≮≯ ❝❞  @ @ § ※ # ~ £ ¥ $ € 
 
(四)表格符号
┏ ┳ ┓┏ ┯ ┓┌ ┬ ┐╔ ╦ ╗╓ ╥ ╖╒ ╤ ╕─│╭ ╮╱ ╲ ┱ ┲ ╃ ╄ 
┣ ╋ ┫┠ ┼ ┨├ ┼ ┤╠ ╬ ╣╟ ╫ ╢╞ ╪ ╡━ ╰ ╯╲ ╱ ┇┅ ┋
┗ ┻ ┛┗ ┷ ┛└ ┴ ┘╚ ╩ ╝╙ ╨ ╜╘ ╧ ╛═║ ︴ ﹏ ﹋ ﹌
 
(五)箭头符号
♂ ♂ ↑ ↓ ← → ↖ ↗ ↙ ↘ ↔ ↕ ☇ ☈ ➸ ➹ ➳➴➵ ➽ ◀ ◁ ▶ ▷ ▲ △ ▼ ▽ ◄ ► ☜ ☞
 
(六)音乐符号
♩ ♪ ♫ ♬ ♯♭♮ 
 
(七)上标字符
℡ ™ º ¹ ² ³ ª °  
 
(八)数字、数学符号
⓪ ① ② ③ ④ ⑤ ⑥ ⑦ ⑧ ⑨ ⑩ ⑪ ⑫ ⑬ ⑭ ⑮ ⑯ ⑰ ⑱ ⑲ ⑳ 
❶ ❷ ❸ ❹ ❺ ❻ ❼ ❽ ❾ ❿ 
⑴ ⑵ ⑶ ⑷ ⑸ ⑹ ⑺ ⑻ ⑼ ⑽ ⑾ ⑿ ⒀ ⒁ ⒂ ⒃ ⒄ ⒅ ⒆ ⒇ 
⒈ ⒉ ⒊ ⒋ ⒌ ⒍ ⒎ ⒏ ⒐ ⒑ ⒒ ⒓ ⒔ ⒕ ⒖ ⒗ ⒘ ⒙ ⒚ ⒛
ⅰ ⅱ ⅲ ⅳ ⅴ ⅵ ⅶ ⅷ ⅸ ⅹ ⅺ ⅻ 
Ⅰ Ⅱ Ⅲ Ⅳ Ⅴ Ⅵ Ⅶ Ⅷ Ⅸ Ⅹ Ⅺ Ⅻ
㊀ ㊁ ㊂ ㊃ ㊄ ㊅ ㊆ ㊇ ㊈ ㊉ 
㈠ ㈡ ㈢ ㈣ ㈤ ㈥ ㈦ ㈧ ㈨ ㈩ 
№ ⅛ ¼ ⅜ ½ ⅝ ¾ ⅞ ⅓ ⅔
+ - × ÷ ± + - = ≡ ≠ ≒ ≈ ≌ ~ ~﹢ ╳ ⊕ Θ % % ‰ ∵ ∴ ∷ ∏ < > ≦ ≧ ≤ ≥﹤ ﹥
∩ ∪ ∈ ¢ ° ⊥ ∠ ∟ ⊿ △ ㏒ ∑ ∂ ∫∮∞( 〔 ﹙﹚ 〕) { ﹛﹜} √ ㄨ
 
(九)特殊中文字符
㊐ ㊊ ㊎ ㊍ ㊌ ㊋ ㊏ ㊑ ㊒ ㊓ ㊔ ㊕ ㊖ ㊗ ㊘ ㊜ ㊝ ㊞ ㊟ ㊠ ㊡ ㊢ ㊩ ㊪ ㊫ ㊬ ㊭ ㊮ ㊯ ㊰ ㊙ ㊚
 ㊛ ㊣ ㊤ ㊥ ㊦ ㊧ ㊨ 
㈱ ㍿ 囍 卐 卍 ォミ灬 彡 ツ
 
(十)特殊西文字符
⒜ ⒝ ⒞ ⒟ ⒠ ⒡ ⒢ ⒣ ⒤ ⒥ ⒦ ⒧ ⒨ ⒩ ⒪ ⒫ ⒬ ⒭ ⒮ ⒯ ⒰ ⒱ ⒲ ⒳ ⒴ ⒵ 
ⓐ ⓑ ⓒ ⓓ ⓔ ⓕ ⓖ ⓗ ⓘ ⓙ ⓚ ⓛ ⓜ ⓝ ⓞ ⓟ ⓠ ⓡ ⓢ ⓣ ⓤ ⓥ ⓦ ⓧ ⓨ ⓩ 
Ⓐ Ⓑ Ⓒ Ⓓ Ⓔ Ⓕ Ⓖ Ⓗ Ⓘ Ⓙ Ⓚ Ⓛ Ⓜ Ⓝ Ⓞ Ⓟ Ⓠ Ⓡ Ⓢ Ⓣ Ⓤ Ⓥ Ⓦ Ⓧ Ⓨ Ⓩ
 [̲̅A̲̅][̲̅B̲̅][̲̅C̲̅][̲̅D̲̅][̲̅E̲̅][̲̅F̲̅][̲̅G̲̅][̲̅H̲̅]
[̲̅I̲̅][̲̅J̲̅][̲̅K̲̅][̲̅L̲̅][̲̅M̲̅][̲̅N̲̅][̲̅O̲̅][̲̅P̲̅]
[̲̅Q̲̅][̲̅R̲̅][̲̅S̲̅][̲̅T̲̅][̲̅U̲̅][̲̅V̲̅][̲̅W̲̅][̲̅X̲̅][̲̅Y̲̅][̲̅Z̲̅]
à á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ø ù ú û ü ý þ ÿ ō ǒ ǎ 
À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö Ø Ù Ú Û Ü Ý Þ ß ε ф μ ξ ζ ω Ω ψ Ψ Café 
a b c d e f g h i j k l m n o p q r s t u v w x y z   
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 
© ® ℗ ℃ ℉ Ω ㏎  
 
(十一)时间与日期
㍘ ㍙ ㍚ ㍛ ㍜ ㍝ ㍞ ㍟ ㍠ ㍡ ㍢ ㍣ ㍤ ㍥ ㍦ ㍧ ㍨ ㍩ ㍪ ㍫ ㍬ ㍭ ㍮ ㍯ ㍰
㋀ ㋁ ㋂ ㋃ ㋄ ㋅ ㋆ ㋇ ㋈ ㋉ ㋊ ㋋
㏠ ㏡ ㏢ ㏣ ㏤ ㏥ ㏦ ㏧ ㏨ ㏩ ㏪ ㏫ ㏬ ㏭ ㏮ ㏯ ㏰ ㏱ ㏲ ㏳ ㏴ ㏵ ㏶ ㏷ ㏸ ㏹ ㏺ ㏻ ㏼ ㏽ ㏾
 
(十二)注音符号
ㄅ ㄆ ㄇ ㄈ ㄉ ㄊ ㄋ ㄌ ㄍ ㄎ ㄏ ㄐ ㄑ ㄒ ㄓ ㄔ ㄕ ㄖ ㄗ ㄘ ㄙ ㄚ ㄛ ㄜ ㄝ ㄞ ㄟ ㄠ ㄡ ㄢ ㄣ ㄤ
 ㄥ ㄦ ㄧ ㄨ ㄩ 々
ā á ǎ à ō ó ǒ ò ē é ě è ī í ǐ ì ū ú ǔ ù ǖ ǘ ǚ ǜ ü
 
(十三)组合符号
表情:。◕‿◕。  。◕‿◕。  ⊙‿⊙  (◡‿◡✿)  (◕‿◕✿)  *⊹⊱✿◕‿◕✿⊰⊹* :-)  :)  ☺  ☻ 
           (◕〝◕)  ๏[-ิิ_•ิ]๏  o(‧'''‧)o  べòべ  ◉◞◟◉  ☼ ◦ ☼  *^_^*  ^*^  ^-^  ^_^  ^︵^
           ⌒_⌒  ︶︹︺  。◕‿-。  ⌒ǒ⌒ ~⌒ō⌒~  :-(  ≈(  ~.~  •.•  •‿•  p( ^ O ^ )q 
文字:ⓛⓞⓥⓔ  ⓜⓘⓢⓢ  ⓨⓞⓤ
其他:๑۩۞۩๑  ๑۩۩๑  ☜♥☞ ╰☆╮  ╭★╯  ⊹⊱⋛⋋ ⋌⋚⊰⊹  ۰•●❀ ❀●•۰  εїз  

Oracle Control File 物理结构

CONTROL FILE

The Control file stores ‘state’ of the database.

This information is not stored in any other file.

 

·        Block 1 – Offset : 2048 - Control File Header

 

Typ

Ver

Not used

Block ID

Seq No

Not used

Flags

15

02

00

00

01

00

00

00

34

00

00

00

ff

ff

01

04

 

Chk Val

Not used

Server Version

Compatibility Vers

DBID

17

82

00

00

00

00

00

08

00

00

00

08

E1

EA

3E

34

 

DBNAME

Ctrl Seq No

No. Of Blocks

4f

52

43

4c

00

00

00

00

34

00

00

00

c4

04

00

00

 

Block Size

FileNo

Filetype

Not used

00

08

00

00

00

00

01

00

00

00

00

00

00

00

00

00

Not used

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

Not used

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

DBID (chngs at strtup)

Creation DTTM

Checkpoint SCN

Not used

E1

EA

3E

34

63

9F

C9

14

40

09

00

00

00

00

14

00

 

Chkpt DTTM

Threadno

Notused

RBA

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

RBA

Not used

Enable Threads

Block No (DataBase)

00

00

00

00

00

00

00

00

00

00

00

00

01

00

00

00

 

Size

Max No

In Use

Not Used

Last Recid

c0

00

01

00

01

00

00

00

00

00

00

00

00

00

00

00

 

Block No

Size

Max No

In Use

Not Used

02

00

00

00

f4

03

10

00

00

00

00

00

00

00

00

00

 

Last Recid

BlkNo(Chkpt,redoth

Size

Max No

In Use

Not Used

00

00

00

00

0a

00

00

00

68

00

10

00

01

00

00

00

 

Not Used

Last Recid

Block No(LogFile)

Size

Max No

00

00

00

00

00

00

00

00

0b

00

00

00

48

00

20

00

 

In Use

Not USed

Last Recid

Block No(Datafile)

02

00

00

00

00

00

00

00

02

00

00

00

0d

00

00

00

 

Size

Max No

In USe

Not Used

Last Recid

b4

00

20

00

02

00

00

00

00

00

00

00

02

00

00

00

 

Block No (Names)

Size

Max no

In use

Not used

10

00

00

00

0c

02

61

00

04

00

00

00

00

00

00

00

 

Last Recid

Blk No(TBLSPACE)

Size

Max No

In use

Not Used

00

00

00

00

2a

00

00

00

44

00

20

00

02

00

00

00

 

Not Used

Last Recid

Block id

Size

Max No

00

00

00

00

02

00

00

00

2c

00

00

00

01

00

01

00

 

In Use

Not used

Last Recid

Block No

00

00

00

00

00

00

00

00

00

00

00

00

2d

00

00

00

 

Size

Max No

In Use

Not USed

Last Recid

01

00

01

00

00

00

00

00

00

00

00

00

00

00

00

00

 

Block No (Loghist)

Size

MaxNo

In Use

SeqNo

Last Record

2e

00

00

00

24

00

5e

06

0b

00

01

00

0b

00

00

00

 

Last Recid

Block No(Offline)

Size

Max

In Use

Not Used

0b

00

00

00

4b

00

00

00

38

00

24

00

00

00

00

00

 

Not Used

Last Recid

Block No(Arch Log)

Size

Max

00

00

00

00

00

00

00

00

4c

00

00

00

48

02

41

06

 

In Use

Not Used

Last Recid

Block No

00

00

00

00

00

00

00

00

00

00

00

00

1a

02

00

00

 

Size

Max

In Use

Not Used

Last Recid

28

00

32

00

00

00

00

00

00

00

00

00

00

00

00

00

 

Block No

Size

Max

In Use

Not Used

1b

02

00

00

e0

02

42

00

00

00

00

00

00

00

00

00

 

Last Recid

Block No

Size

Max

In Use

Not used

00

00

00

00

33

02

00

00

74

00

45

00

00

00

00

00

 

Not Used

Last Recid

Block No

Size

Max

00

00

00

00

00

00

00

00

37

02

00

00

4c

00

4f

00

 

In Use

Not Used

Last Recid

Block No

00

00

00

00

00

00

00

00

00

00

00

00

3a

02

00

00

 

Size

Max

In Use

Not Used

Last Recid

94

02

40

00

00

00

00

00

00

00

00

00

00

00

00

00

 

Block No

Size

Max

In Use

Not Used

4f

02

00

00

2c

00

2e

00

00

00

00

00

00

00

00

00

 

Last Recid

Block No

Size

Max

In Use

Not used

00

00

00

00

50

02

00

00

28

00

32

00

00

00

00

00

 

Not Used

Last Recid

Block No

Size

Max

00

00

00

00

00

00

00

00

51

02

00

00

14

00

53

06

 

In Use

Not Used

Last Recid

Block No

00

00

00

00

00

00

00

00

00

00

00

00

61

02

00

00

 

Size

Max

In use

Not used

Last Recid

01

00

e8

07

00

00

00

00

00

00

00

00

00

00

00

00

 

Block No

Size

Max No

In use

Not used

62

02

00

00

01

00

e8

07

00

00

00

00

00

00

00

00

 

Last Recid

Block No

Size

Max No

In use

Not used

00

00

00

00

00

80

00

00

00

20

00

00

00

00

00

00

 

Not used

Last Recid

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

             Offset – 1831

 

 

 

 

 

 

 

 

DF Version

Comp Version

00

00

00

00

00

00

00

00

00

00

00

08

00

00

00

08

 

DTTM

DBName    - ORCL

Not used

61

9f

C9

14

4f

52

43

4c

00

00

00

00

00

00

00

00

 

Not used

DF Flags

Implicit Recovery SCN

Not used

0f

02

40

00

00

40

00

00

00

00

00

00

00

00

00

00

 

Reset Log SCN

Not used

DTTM

Prior Reset

01

00

00

00

00

00

00

00

61

9f

C9

14

00

00

00

00

 

Log SCN

Not used

Date Time

Redo Version Creat

Redo Comp Vers

00

00

00

00

00

00

00

00

00

00

00

08

00

00

00

08

 

No. of DataFile

No. of Online File

Thread

Not used

DB Chkpnt SCN

02

00

00

00

02

00

00

00

01

00

00

00

3A

09

00

00

 

 

Not USed

Thrd En

Open

Head

Tail

Enabled Thread

00

00

61

00

01

00

00

00

00

00

00

00

02

00

00

00

 

Enabled Thread

Max Log

Max Data

Head

Tail

Force SCN

00

00

00

00

02

00

01

00

00

00

00

00

30

07

00

00

 

FrceSCN

Not used

00

00

b9

04

00

00

00

00

00

00

00

00

00

00

00

00

Not used

00

00

00

00

00

00

00

00

00

00

00

00

0a

00

0a

00

Not used

61

9f

C9

14

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

00

 

 

 

 

 

 

 

 

 

 

 

 

Tail

00

00

00

00

00

00

00

00

00

00

00

00

01

15

34

00

About this Archive

This page is an archive of entries from March 2007 listed from newest to oldest.

August 2006 is the previous archive.

April 2007 is the next archive.

Find recent content on the main index or look in the archives to find all content.