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!

Create tablespace in Oracle 11g

johnpau2013Jan 16 2013 — edited Jan 16 2013

Windows 2008 R2 (64-bit OS)
Oracle 11g R2 Standard Edition ONE(64-bit database)

I use the following Oracle command to create tablespace in 11g.

CREATE TABLESPACE TEST_TBS
DATAFILE
'C:\ORACLE\ORADATA\TEST_TBS01.DBF' SIZE 5M
AUTOEXTEND ON NEXT 5M
MAXSIZE 50000M;

- The above command works fine.

Is there any better commands i need to be using in creating a tablespace w.r.t. performance and management.

This post has been answered by JohnWatson on Jan 16 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2013

Added on Jan 16 2013

#general-database-discussions

7 comments

1,331 views