Today I noticed an interesting fact about Oracle data file by accident -- a data file name can cantain white space! I added a few temp data files and then I thought that's more than enough. So I tried to drop and got the following error: SQL> alter database tempfile '/dbase/system/PROD/temp15.dbf' drop INCLUDING DATAFILES; alter … Continue reading Interesting fact — having space within data file name
Day: February 1, 2021