✍ Kashif M
Trends

Monday, 15 July 2013


Oracle Tablespace in LINUX


By on July 15, 2013



Want to create tablespace in linux which handle any sort of data?

If you creating any Production environment, Please do create your own tablespace and assign users for that tablespace


Here is the query for you 


 CREATE TABLESPACE oracle DATAFILE
'/oracle/obi_tablespace/oracle.dbf' SIZE 31G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

Kashif
mkashu: Oracle Tablespace in LINUX
Review : Kashif | Kashif
Update: July 15, 2013 | Rating: 4.5

Comment for "Oracle Tablespace in LINUX"

0 comments

Post a Comment

Blog Archive