Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablespace

795083Sep 3 2010 — edited Sep 3 2010

hello experts,

I added datafile in USERS tablespace of 5 GB
but i fire a query : -

select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name='USERS';

it shows : -

FILE_NAME
--------------------------------------------------------------------------------
BYTES AUT MAXBYTES
---------- --- ----------
/home/orabidh/u01/app/bidh/users04.dbf
5368709120 NO 0

/home/orabidh/u01/app/bidh/users05.dbf
5368709120 NO 0

why its happen ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2010

Added on Sep 3 2010

#general-database-discussions

5 comments

688 views