SQL> alter tablespace XNCBS add datafile '+DATRP' SIZE 5g autoextend on next 200M
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
SQL> SELECT name, issys_modifiable from v$parameter where name ='db_files';
NAME
--------------------------------------------------------------------------------
ISSYS_MOD
---------
db_files
FALSE
这里必须重启才能生效
CDB里面改了就可以
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 200
SQL> alter system set db_files=400 scope=spfile;
System altered.
SQ>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4.9661E+10 bytes
Fixed Size 30040104 bytes
Variable Size 1.7985E+10 bytes
Database Buffers 3.1541E+10 bytes
Redo Buffers 104173568 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PJNCS1 READ WRITE NO
4 PJDCS2 READ WRITE NO
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 400
SQL> alter session set container=PJDYCS1 ;
Sssion altered.
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 400
SQL>