Skip to Main Content
Forums

SQL & PL/SQL

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!

Create Tablespace

1011859Sep 14 2013 — edited Sep 14 2013

CREATE TABLESPACE tablespacename DATAFILE 'Path'

SIZE 1000M

AUTOEXTEND ON MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

if i create the tablespace with following statement, upto what extend the datafile size can grow (is it OS dependent)?

If my tablespace is nearly 95% occupied, then do i need to manually resize the datafile?

Thanks

Akhi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2013
Added on Sep 14 2013
2 comments
248 views