Database Administration (MOSC)

MOSC Banner

Oracle Datafiles shows same name

edited Apr 8, 2017 5:00AM in Database Administration (MOSC) 7 commentsAnswered

How to change the datafile name for the below datafiles and how to increase the system datafile in Windows environment? I guess I have created the datafiles wrongly and these are OMF. Please help in resolving this issue.

SQL> SELECT SUBSTR (df.NAME, 1, 40) file_name,dfs.tablespace_name, df.bytes / 1024 / 1024 allocated_mb,

  2  ((df.bytes / 1024 / 1024) -  NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb,

  3  NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb

  4  FROM v$datafile df, dba_free_space dfs

  5  WHERE df.file# = dfs.file_id(+)

  6  GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes,dfs.tablespace_name

  7  ORDER BY file_name;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

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