Database Administration (MOSC)

MOSC Banner

tablespace datafile size

edited Feb 17, 2014 3:33AM in Database Administration (MOSC) 3 commentsAnswered

we have database which previously resided in EXADATA and then moved to a standalone linux host in which im seeing undo  datafile size as 100g,as far as i know normal tablespaces wouldnt exceed 32g size of datafile unless it is a bigfile tablespace,i see this weird situation where normal tablespace has 100g size..

is that possible to have datafile size like this..?

SQL> SELECT tablespace_name, bigfile FROM dba_tablespaces;

TABLESPACE_NAME                BIGFILE

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

UNDOTBS1                       NO

           FILE_NAME                                     SUM(BYTES/1024/1024/1024)  

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

data_D-OBIAPRD_I-1778060744_TS-UNDOTBS2_FNO-11_p8nkgims         100

Thanks!

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