theDBA_PDBSandCDB_DATA_FILESviews to show the name and location of each data file for all of the PDBs in a CDB, including the CDB seed. 这说明cdb_data_files确实有pdb$seed的信息。 在MOS中,文档(1940806.1) PDB$SEED Datafiles Not Appear In CDB_DATA_FILES 介绍是参数EXCLUDE_SEED_CDB_VIEW ...
theDBA_PDBSandCDB_DATA_FILESviews to show the name and location of each data file for all of the PDBs in a CDB, including the CDB seed. 这说明cdb_data_files确实有pdb$seed的信息。 在MOS中,文档(1940806.1) PDB$SEED Datafiles Not Appear In CDB_DATA_FILES 介绍是参数EXCLUDE_SEED_CDB_VIEW ...
select c.name cdbname,d.file# dfile,d.name dbfile,round(f.bytes/1024/1024/1024,2) size_gb,f.AUTOEXTENSIBLE ,d.CREATION_TIME from v$datafile d,v$containers c,cdb_data_files f where c.con_id=d.con_id and d.name=f.file_name order by cdbname,d.creation_time; --查看每个pdb下用户...
ALTERPLUGGABLE DATABASE orclpdb OPEN READ WRITE; ALTERPLUGGABLE DATABASE orclpdb OPEN READ ONLY; 1. 2. 查询PDB文件: SELECTp.PDB_ID,p.PDB_NAME,d.FILE_ID,d.TABLESPACE_NAME,d.FILE_NAME FROMDBA_PDBS p,CDB_DATA_FILES d WHEREp.PDB_ID=d.CON_ID ORDERBYp.PDB_ID; 1. 2. 3. 4. 启/...
SYS@cdbtest> select file_name,con_id from cdb_data_files where con_id =1 ; FILE_NAME CON_ID --- --- /u01/app/oracle/oradata/cdbtest/system01.dbf 1 /u01/app/oracle/oradata/cdbtest/sysaux01.dbf 1 /u01/app/oracle/oradata/cdbtest...
不限制create tablespace aeolian_tablespace datafile'aeolianfile.dbf'size 100M autoextend on next 5M maxsize unlimited;;#临时表空间创建create temporary tablespace aeolian_template_tablespace tempfile'aeoliantempfile.dbf'size 10m;#查看表空间及其文件位置select file_name,tablespace_name from dba_data_files;...
这里通过查询 cdb_data_files 视图查询数据文件所在位置,如下图,发现出现了一串字母数字组成的目录结构,这个是由于 Oracle 使用 OMF 管理,使用 GUID 来作为目录结构唯一标识一个 PDB 。而当使用 dba_data_files 视图来查看数据文件时只查看到当前容器即CDB$ROOT 中的数据文件,使用 cdb_data_files 时才看到了所有...
Example 43-7 Showing the Data Files for Each PDB in a CDB COLUMN PDB_ID FORMAT 999 COLUMN PDB_NAME FORMAT A8 COLUMN FILE_ID FORMAT 9999 COLUMN TABLESPACE_NAME FORMAT A10 COLUMN FILE_NAME FORMAT A45 SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME ...
FROM cdb_data_files; 探究用户 desc dba_users desc cdb_users SELECT username, account_status, lock_date, expiry_date FROM dba_users ORDER BY 1; SELECT username, default_tablespace, temporary_tablespace FROM dba_users ORDER BY 1; SELECT username, default_tablespace, temporary_tablespace, con_id...
alter pluggable database p1 open read write ; 4.插入一个以前拔出的PDB #数据文件拷贝过去alter pluggable database m1 close;alter pluggable database m1 unpluginto'/home/oracle/to_pdb.xml'#删除数据库和文件#drop pluggable database m1 including datafiles ;#删除数据库 保存文件#drop pluggable databas...