Create Tablespace Examples
Creating a normal and permanent tablespace is pretty regular practice for a DBA whenever application needs it, comparing to creating a temporary tablespace. In this… Read More »Create Tablespace Examples
reuse
How to Resolve ORA-15005: name is already used by an existing alias
ORA-15005 ORA-15005 means that there's already a file with the same name existing in the same path. Therefore, Oracle cannot create the file for you.… Read More »How to Resolve ORA-15005: name is already used by an existing alias
How to Resolve ORA-27038: created file already exists
ORA-27038 Tried to add a data file to a tablespace, but it failed with ORA-27038. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example03.dbf' size 10m autoextend… Read More »How to Resolve ORA-27038: created file already exists