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!

Creating TableSpaces In Oracle 11g

Rajan SwSep 21 2012 — edited Sep 21 2012

Hi Guys,

I have to create some tablespaces for our development database.
Currently I am creating tablespaces like below

CREATE TABLESPACE tools
DATAFILE '/data/oracle/oradata/tpol/tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE cash_box_data_tbs
DATAFILE '/data/oracle/oradata/tpol/cash_box_data01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE cash_box_ndx_tbs
DATAFILE '/data/oracle/oradata/tpol/cash_box_ndx01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE cash_drawer_data_tbs
DATAFILE '/data/oracle/oradata/tpol/cash_drawer_data01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE cash_drawer_ndx_tbs
DATAFILE '/data/oracle/oradata/tpol/cash_drawer_ndx01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

I am wondering is there any way to set the path to /data/oracle/oradata/tpol/ and If I create the table space automatically the datafile sould be created in the above path.

Please give me some suggestions .I am using Oracle 11g

This post has been answered by kuljeet singh - on Sep 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2012

Added on Sep 21 2012

#general-database-discussions

2 comments

11,695 views