Database Administration (MOSC)

MOSC Banner

Creating dba directories and using the same to create datafile (ASM)

Dears,

can you let me what's wrong here.. Why the datafiles not getting created on dba directories. Its creating the datafiles in ORACLE_HOME not using diskgroup path.


SQL> create directory OBDX_DIR as '+DATA/<DB>/<PDB>/DATAFILE/';

Directory created.

SQL> create tablespace TEST datafile 'OBDX_DIR' size 1M autoextend on maxsize 2M;

Tablespace created.

SQL> select file_name from dba_data_files where tablespace_name='TEST';FILE_NAME

--------------------------------------------------------------------------------

/<ORACLE_HOME>/dbs/OBDX_DIR

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center