How to view the datafiles & tempfiles in PDB?
If we have created PDB's the easiest way to view the datafiles in using v$datafile.
We also can connect to the CDBROOT and list details of all datafiles which include PDB's as well.
To view the tempfiles of both PDB's and CDB's we can query v$tempfile as we do in other releases.
In case if you want to view only the details of individual PDB's you need to set the session to that particular database and view them.
If we have created PDB's the easiest way to view the datafiles in using v$datafile.
We also can connect to the CDBROOT and list details of all datafiles which include PDB's as well.
To view the tempfiles of both PDB's and CDB's we can query v$tempfile as we do in other releases.
In case if you want to view only the details of individual PDB's you need to set the session to that particular database and view them.
No comments:
Post a Comment