# 示例：检查Oracle 9i版本
SQL> SELECT * FROM v$version;

BANNER
—————————————————————-
Oracle9i Enterprise Edition Release 9.2.0.8.0 – Production
PL/SQL Release 9.2.0.8.0 – Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 – Production
NLSRTL Version 9.2.0.8.0 – Production

# 示例：启用XML支持
SQL> CREATE TABLE xml_table (
id NUMBER PRIMARY KEY,
xml_data XMLType
);

Table created.

SQL> INSERT INTO xml_table VALUES (
1,
XMLType(‘John DoeIT‘)
);

1 row created.

SQL> SELECT xml_data.extract(‘/employee/name/text()’).getStringVal() AS name
FROM xml_table;

NAME
—————-
John Doe

# 示例：检查Oracle 10g版本
SQL> SELECT * FROM v$version;

BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bi
PL/SQL Release 10.2.0.5.0 – Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 – Production
NLSRTL Version 10.2.0.5.0 – Production

# 示例：使用自动存储管理(ASM)
SQL> SELECT name, state FROM v$asm_diskgroup;

NAME STATE
—————————— ———–
DATA MOUNTED
FRA MOUNTED

# 示例：使用自动工作负载仓库(AWR)
SQL> EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();

PL/SQL procedure successfully completed.

SQL> SELECT * FROM dba_hist_snapshot WHERE rownum <= 5;

SNAP_ID DBID INSTANCE_NUMBER STARTUP_TIME BEGIN_INTERVAL_TIME END_INTERVAL_TIME FLUSH_ELAPSED SNAP_LEVEL ERROR_COUNT
——- —- ————— ————– ———————— ———————— ————- ———– ————
1 1234 1 2026-04-05 10:00 2026-04-05 10:00:00.000 2026-04-05 11:00:00.000 00:00:01.234 1 0

# 示例：使用Export/Import迁移到Oracle 10g
— 从旧版本导出
$ exp system/password@old_db full=y file=full.dmp log=exp.log

— 导入到Oracle 10g
$ imp system/password@new_db full=y file=full.dmp log=imp.log

# 示例：使用Data Pump迁移到Oracle 10g
— 导出
$ expdp system/password@old_db full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=expdp.log

— 导入
$ impdp system/password@new_db full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=impdp.log

# 迁移后检查
SQL> SELECT * FROM v$version;
SQL> SELECT count(*) FROM user_tables;
SQL> SELECT count(*) FROM user_indexes;