接触了一个Oracle10g Express Edition的数据库,青年人网站提示:这是第一次见识Express的生产版本。: q1 k; b2 w; I6 f
其Banner信息如下:, V! J7 L+ ?2 U1 a) w: Z) t
SQL> select * from v$version;5 x6 _) S, i% t* s
BANNER8 f. m* l8 a$ E3 x3 e. a7 b
Oracle Database 10g Express Edition Release 10.2.0.1.0 Product
1 |# O+ R6 n5 |1 s' p! Y PL/SQL Release 10.2.0.1.0 Production* s* A; ^% q" ^
CORE 10.2.0.1.0 Production, y, R( i% V. y: w6 Y2 p
TNS for Linux: Version 10.2.0.1.0 Production
# P( b$ \0 @! |+ e& h& T& V& i1 Y NLSRTL Version 10.2.0.1.0 Production: n! x3 M5 B( p
查看了一下Express版本的数据库选件,发现大部分都是False的:8 s+ n7 a: F% W( s
SQL> select * from v$option order by value;$ u3 D$ c1 W. r
PARAMETER /VALUE# D- m+ ?( e) C1 w2 ]6 A9 i; l3 M, w
Partitioning /FALSE) p. Y" y8 d$ Y
Export transportable tablespaces /FALSE
' S# z) s J, k5 Y$ G& `* B Backup Encryption /FALSE5 A( ]. `7 R3 ?8 { k$ O
Transparent Data Encryption /FALSE
# w' F) |8 x3 d- [1 E3 y0 o: t" G Data Mining Scoring Engine /FALSE/ o5 z" U+ @* Q7 \( K$ p
Flashback Database /FALSE/ J m0 k/ L" x
Flashback Table /FALSE, C5 G& P! G) r
Block Change Tracking /FALSE
# z- E# s9 n) `" F; M/ R R" ~ File Mapping /FALSE
' k, \& H- s: C' P" M: B. @/ B6 T+ [ Streams Capture /FALSE5 K4 Q; M2 `0 W8 m
Online Redefinition /FALSE3 a+ a" I2 Y; N6 Q
PARAMETER /VALUE! a; J9 o1 G5 P& h. Y6 a
Data Mining /FALSE
& X! Y3 c! _6 K Trial Recovery /FALSE
' X# a3 _0 k5 g Real Application Clusters /FALSE2 C: i$ Q$ z O. o
Advanced replication /FALSE. [: Y/ i& V( w5 G- t g- {6 a
Bitmapped indexes /FALSE+ k* b8 x6 @' W8 v5 `8 C
Parallel backup and recovery /FALSE
; D9 |! e# S8 a( } Parallel execution /FALSE+ r! ?, W7 Z6 P4 C8 c6 ^
Pointintime tablespace recovery /FALSE
" r+ X+ b6 d! H6 p, N9 | Finegrained access control /FALSE( D0 v) y, C. z4 a3 Y
Change Data Capture /FALSE6 `7 ]4 E) p( T
Online Index Build /FALSE2 l! `2 \) |: H
PARAMETER /VALUE
! _$ J% ]7 y; m% N& J$ ] Coalesce Index /FALSE/ L7 G1 ^) g- Q
Managed Standby /FALSE$ ?: r5 v0 F5 e" E0 ?: O
Materialized view rewrite /FALSE
) J! z- U j' G! M2 B Materialized view warehouse refresh /FALSE9 o2 T% J5 L# m- Z
Database resource manager /FALSE
! @6 u9 m$ u0 n7 r% R Spatial /FALSE# N' \2 a, U3 ]
Visual Information Retrieval /FALSE/ ~( m3 w0 Z; X1 ]& G
Unused Block Compression /FALSE" s3 D3 m# L8 m, }1 e$ _
FastStart Fault Recovery /FALSE
$ ?8 f7 j5 J3 { Duplexed backups /FALSE |