OFFLINE TABLESPACE

-
alter tablespace userdata offline;


Statement processed. 


0.31 seconds

select tablespace_name ,status ,contents  from dba_tablespaces;

USERDATA OFFLINE  PERMANENT

Comments

Post a Comment

Popular posts from this blog

ADD DATAFILE TO USERDATA

-
alter  tablespace userdata add datafile 'C:\oraclexe\oradata\xe\userdata2.dbf' size 2m; Statement processed. 0.55 seconds SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERDATA'; USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF 5 USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF 7 SELECT  FILE_NAME, BLOCKS    FROM DBA_DATA_FILES where TABLESPACE_NAME = 'USERDATA'; FILE_NAME                                                       BLOCKS C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF    256 C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF    256
Read more

CREATE TABLESPACE

-
create tablespace userdata datafile 'C:\oraclexe\oradata\xe\data1.dbf' size 1m; Statement processed. 0.58 seconds select tablespace_name ,status ,contents  from dba_tablespaces; USERDATA ONLINE PERMANENT select tablespace_name ,status ,contents , block_size from dba_tablespaces; USERDATA ONLINE  PERMANENT    8192
Read more