Friday, March 28, 2014

How to create a tablespace named TABLE in Oracle :

Connect  Sys as sysdba 

CREATE TABLESPACE TABLES  DATAFILE 
'D:\APP\MOHANTY\ORADATA\ORCL\TABLES.DBF' SIZE 125440K AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

-- The default table space can be  changed by the below command .

Alter database default tablespace TABLES; 

SELECT USERNAME, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE
from DBA_USERS
where USERNAME='HR';

--Next time when we will create a table by CREATE TABLE COMMAND it will be in "TABLES"  tablespace.

Cheers
Rajani

No comments:

Post a Comment