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