上海国外网站建设,iis怎么加载网站,kxsw wordpress,昆明app外包注#xff1a;本文谢绝转载。1 管理CDB中的表空间CDB表空间的管理和non-CDB 表空间的管理一样#xff0c;CDB 也有一个实例#xff0c;在安装的时候指定。--查看表空间#xff1a;SQL select instance_name fromv$instance;INSTANCE_NAME----------------CndbaSQL…注本文谢绝转载。1 管理CDB中的表空间CDB表空间的管理和non-CDB 表空间的管理一样CDB 也有一个实例在安装的时候指定。--查看表空间SQL select instance_name fromv$instance;INSTANCE_NAME----------------CndbaSQL col file_name for a50SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME------------------------------ ------------------------------------------------------------USERS 6 /u01/app/oracle/oradata/cndba/users01.dbfUNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbfSYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbfSYSTEM 1 /u01/app/oracle/oradata/cndba/system01.dbf--切换containerSQL set lin 140SQL select con_id, dbid, guid, name ,open_mode from v$pdbs;CON_ID DBID GUID NAME OPEN_MODE---------- ------------------------------------------ ------------ ----------2 4088301206 F7C1E3C96BBF0585E0430A01A8C05459 PDB$SEED READ ONLY3 426143573F7C209EB1DFC0854E0430A01A8C0B787 PDBCNDBA READ WRITE4 1231796139 F812DE1B6A8F363AE0430A01A8C0C759 PCNDBA2 READ WRITESQL alter session setcontainerpcndba2;Session altered.SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME----------------- ------------------------------------------------------------SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbfSYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbfUSERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf--表空间具体操作示例SQL alter session setcontainerCDB$ROOT;Session altered.SQL show con_nameCON_NAME------------------------------CDB$ROOTSQL CREATE TABLESPACE dave2 DATAFILE‘/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf‘ SIZE 1M3 AUTOEXTEND ON NEXT 1M;Tablespace created.SQL ALTER TABLESPACE dave ADD2 DATAFILE‘/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf‘ SIZE 1M3 AUTOEXTEND ON NEXT 1M;Tablespace altered.--查看SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME------------------------------ ------------------------------------------------------------SYSTEM 1/u01/app/oracle/oradata/cndba/system01.dbfSYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbfUNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbfUSERS 6/u01/app/oracle/oradata/cndba/users01.dbfDAVE 16/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbfDAVE 15/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf--drop表空间SQL drop tablespace dave includingcontents and datafiles;Tablespace dropped.SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME------------------------------ ------------------------------------------------------------SYSTEM 1/u01/app/oracle/oradata/cndba/system01.dbfSYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbfUNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbfUSERS 6/u01/app/oracle/oradata/cndba/users01.dbf2 管理PDB的表空间PDB 表空间的管理和CDB一样只需要切换到正确的container即可。SQL select name,open_mode from v$pdbs;NAME OPEN_MODE------------------------------ ----------PDB$SEED READ ONLYPDBCNDBA READ WRITEPCNDBA2 READ WRITESQL show con_nameCON_NAME------------------------------CDB$ROOTSQL alter session setcontainerpcndba2;Session altered.SQL show con_nameCON_NAME------------------------------PCNDBA2SQL col tablespace_name for a15SQL col file_name for a60SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME--------------- ----------------------------------------------------------------------SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbfSYSAUX 13 /u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbfUSERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbfSQL CREATE TABLESPACE dave2 DATAFILE‘/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf‘ SIZE 1M3 AUTOEXTEND ON NEXT 1M;Tablespace created.SQL ALTER TABLESPACE dave ADD2 DATAFILE‘/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf‘ SIZE 1M3 AUTOEXTEND ON NEXT 1M;Tablespace altered.SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME--------------- ----------------------------------------------------------------------SYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbfSYSTEM 12 /u01/app/oracle/oradata/cndba/pcndba2/system01.dbfUSERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbfDAVE 17/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbfDAVE 18/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbfSQL DROP TABLESPACE dave INCLUDINGCONTENTS AND DATAFILES;Tablespace dropped.SQL selecttablespace_name,file_id,file_name from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME--------------- ----------------------------------------------------------------------SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbfSYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbfUSERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf3 Undo 表空间CDB中的undo 表空间只能从CDB中管理不能从non-CDB中管理。PDB 没有自己的undo 表空间PDB 中直接使用CDB中的undo 表空间。如果连上PDB是看不到undo 表空间的。SQL show con_nameCON_NAME------------------------------PCNDBA2SQL select tablespace_name fromdba_tablespaces;TABLESPACE_NAME---------------SYSTEMSYSAUXTEMPUSERS--切换到CDB中SQL alter session setcontainerCDB$ROOT;Session altered.SQL show con_nameCON_NAME------------------------------CDB$ROOTSQL select tablespace_name fromdba_tablespaces;TABLESPACE_NAME---------------SYSTEMSYSAUXUNDOTBS1TEMPUSERSSQL select name from v$datafile;NAME----------------------------------------------------------------------/u01/app/oracle/oradata/cndba/system01.dbf/u01/app/oracle/oradata/cndba/sysaux01.dbf/u01/app/oracle/oradata/cndba/undotbs01.dbf/u01/app/oracle/oradata/cndba/pdbseed/system01.dbf/u01/app/oracle/oradata/cndba/users01.dbf/u01/app/oracle/oradata/cndba/pdbseed/sysaux01.dbf/u01/app/oracle/oradata/cndba/pdbcndba/system01.dbf/u01/app/oracle/oradata/cndba/pdbcndba/sysaux01.dbf/u01/app/oracle/oradata/cndba/pdbcndba/SAMPLE_SCHEMA_users01.dbf/u01/app/oracle/oradata/cndba/pdbcndba/example01.dbf/u01/app/oracle/oradata/cndba/pcndba2/system01.dbf/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf13 rows selected.--查看TEMP表空间SQL select name from v$tempfile;NAME----------------------------------------------------------------------/u01/app/oracle/oradata/cndba/temp01.dbf/u01/app/oracle/oradata/cndba/pdbseed/pdbseed_temp01.dbf/u01/app/oracle/oradata/cndba/pdbcndba/pdbcndba_temp01.dbf/u01/app/oracle/oradata/cndba/pcndba2/temp01.dbfSQL4 Temporary 表空间CDB 中的temporary 表空间只从在CDB中管理。PDB 可以有自己的temporary表空间也可以不用在创建PDB的时候如果没有指定temporary表空间那么就会公用CDB的temporary 表空间。SQL select name from v$pdbs;NAME----------------------------------------------------------------------PDB$SEEDPDBCNDBAPCNDBA2SQL alter session set containerpcndba2;Session altered.SQL show con_nameCON_NAME------------------------------PCNDBA2SQL select file_name fromdba_data_files;FILE_NAME------------------------------------------------------------/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf/u01/app/oracle/oradata/cndba/pcndba2/system01.dbf/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbfSQL CREATE TEMPORARY TABLESPACE temp22 TEMPFILE‘/u01/app/oracle/oradata/cndba/pcndba2/temp02.dbf‘ SIZE 5M3 AUTOEXTEND ON NEXT 1M;Tablespace created.SQL select name from v$tempfile;NAME----------------------------------------------------------------------/u01/app/oracle/oradata/cndba/pcndba2/temp01.dbf/u01/app/oracle/oradata/cndba/pcndba2/temp02.dbfSQL drop tablespace temp2 includingcontents and datafiles;Tablespace dropped.SQL select name from v$tempfile;NAME----------------------------------------------------------------------/u01/app/oracle/oradata/cndba/pcndba2/temp01.dbf5 Default TablespacesCDB 中的defaulttablespace 和 default temporary tablespace 只能在CDB中操作。PDB 的中defaulttablespace 和 default temporary tablespace有两种修改方法(1) 使用ALTER PLUGGABLE DATABASE命令推荐使用这种方法法语如下ALTER PLUGGABLE DATABASE DEFAULT TABLESPACEusers;ALTER PLUGGABLE DATABASE DEFAULT TEMPORARYTABLESPACE temp;(2)为了向后的兼容性也可以使用ALTERDATABASE 命令修改ALTER DATABASE DEFAULT TABLESPACE users;ALTER DATABASE DEFAULT TEMPORARY TABLESPACEtemp;注意不管使用哪种方法在修改之前主要要保证container是正确的。--------------------------------------------------------------------------------------------版权所有文章禁止转载否则追究法律责任!AboutDave:QQ: 251097186Dave 的QQ群--------------------------------------------------------------------------------------------注意:加群必须注明表空间和数据文件关系 | 不要重复加群CNDBA_1: 104207940 (满) CNDBA_2: 62697716 (满) CNDBA_3: 283816689CNDBA_4: 391125754 CNDBA_5: 62697850 CNDBA_6: 62697977 CNDBA_7: 142216823(满)原文http://blog.csdn.net/tianlesoftware/article/details/41820095
