Hello all,
I can't figgure out where in the database creation process how all the tablespaces are being named beginng for example with o1_mf and ending with cb58lw2z_.dbf:
DB_1> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/shared_data/oradata/DB/datafile/o1_mf_system_cb58lw2z_.dbf
/u01/shared_data/oradata/DB/datafile/o1_mf_undotbs3_cb58q00g_.dbf
/u01/shared_data/oradata/DB/datafile/o1_mf_sysaux_cb58krqh_.dbf
/u01/shared_data/oradata/DB/datafile/o1_mf_undotbs1_cb58nbnn_.dbf
/u01/shared_data/oradata/DB/datafile/o1_mf_undotbs2_cb58pznk_.dbf
.
.
.
/u01/shared_data/oradata/DB/datafile/o1_mf_index_cb58pznk_.dbf
Not that it is a big deal, I would like to know how this is happening. Example how I am creating a tablespace:
CREATE bigfile TABLESPACE "INDEXES" LOGGING datafile SIZE 100M AUTOEXTEND ON NEXT 250M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
DB_1> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Thanks!