Oracle修改字符串最大長度

參考 https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/MAX_STRING_SIZE.html 后做以下執行。

Oracle Version: 21.3.0

 

C:\Users\fred.lai>sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on 星期二 5月 14 15:44:09 2024
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


连接到:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 XEPDB1                         MOUNTED
SQL> show user
USER 为 "SYS"
SQL> alter session set container=XEPDB1 ;

会话已更改。

SQL> shutdown immediate;
ORA-65020: 插接式数据库 XEPDB1 已关闭


SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN UPGRADE;
插接式数据库已打开。
SQL> alter system set max_string_size=extended scope=both;

系统已更改。

SQL>  @?/rdbms/admin/utl32k.sql

 

SQL> select count(*) from dba_objects where status<>'VALID';

  COUNT(*)
----------
         0

SQL> shutdown immediate;
插接式数据库已关闭。
SQL> startup;
插接式数据库已打开。

SQL> alter session set container=XEPDB1 ;


SQL>  @?/rdbms/admin/utlrp.sql



SQL> select count(*) from dba_objects where status<>'VALID';

  COUNT(*)
----------
         0

SQL>