Shulou(Shulou.com)06/01 Report--

Some differences between temporary files and regular data files

1 temporary data files are always set to nologging

2 cannot use alter database to create temporary data files

3 Media recovery cannot restore temporary data files

4 when creating a temporary data file, oracle does not always allocate space to it, knowing that it needs to be used

5 the information of the temporary data file does not exist in the data dictionary dba_data_files or v$datafile. The information of the temporary data file is stored.

In dba_temp_files and v$tempfile

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.