{15 その他}VARCHAR2等の最大サイズ制限の緩和

演習

 

https://docs.oracle.com/cd/F19136_01/refrn/MAX_STRING_SIZE.html


sql

show parameter max_string

ALTER SESSION SET CONTAINER=CDB$ROOT;
ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

shutdown immediate;
startup upgrade;

ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;
EXIT;

cd $ORACLE_HOME/rdbms/admin
mkdir -p /home/oracle/utl32k_cdb_pdbs_output

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS       \
-d $ORACLE_HOME/rdbms/admin -l '/home/oracle/utl32k_cdb_pdbs_output' -b utl32k_cdb_pdbs_output utl32k.sql

sql
shutdown immediate;
startup
ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE;
EXIT;


cd $ORACLE_HOME/rdbms/admin
mkdir -p /home/oracle/utlrp_cdb_pdbs_output
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS   \
-d $ORACLE_HOME/rdbms/admin -l '/home/oracle/utlrp_cdb_pdbs_output' -b utlrp_cdb_pdbs_output utlrp.sql