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

BANNER
——————————————————————————-
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
PL/SQL Release 11.2.0.4.0 – Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 – Production
NLSRTL Version 11.2.0.4.0 – Production

# 示例：启用自动内存管理
SQL> ALTER SYSTEM SET memory_target = 8G SCOPE=SPFILE;
SQL> ALTER SYSTEM SET memory_max_target = 12G SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

# 示例：使用间隔分区
SQL> CREATE TABLE fgfgfgsales (
sale_id NUMBER PRIMARY KEY,
sale_date DATE,
amount NUMBER
) PARTITION BY RANGE (sale_date) (
PARTITION p2026q1 VALUES LESS THAN (TO_DATE(‘2026-04-01’, ‘YYYY-MM-DD’)),
PARTITION p2026q2 VALUES LESS THAN (TO_DATE(‘2026-07-01’, ‘YYYY-MM-DD’)),
PARTITION p2026q3 VALUES LESS THAN (TO_DATE(‘2026-10-01’, ‘YYYY-MM-DD’)),
PARTITION p2026q4 VALUES LESS THAN (TO_DATE(‘2027-01-01’, ‘YYYY-MM-DD’))
);

Table created.

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

BANNER CON_ID
——————————————————————————– ———-
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production 0
PL/SQL Release 12.2.0.1.0 – Production 0
CORE 12.2.0.1.0 Production 0
TNS for Linux: Version 12.2.0.1.0 – Production 0
NLSRTL Version 12.2.0.1.0 – Production 0

# 示例：创建可插拔数据库
SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdbadmin IDENTIFIED BY password
FILE_NAME_CONVERT = (‘/oracle/app/oracle/oradata/CDB1/pdbseed/’, ‘/oracle/app/oracle/oradata/CDB1/pdb1/’);

Pluggable database created.

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN;

Pluggable database altered.

SQL> SELECT name, open_mode FROM v$pdbs;

NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 READ WRITE

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

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

— 导入到PDB
$ impdp system/password@cdb1/pdb1 full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=impdp.log

# 迁移后检查
SQL> SELECT * FROM v$version;
SQL> SELECT name, open_mode FROM v$pdbs;
SQL> SELECT count(*) FROM user_tables;