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

LOCALLY MANAGED TS

-
CREATE TABLESPACE lmts DATAFILE 'C:\oraclexe\oradata\xe\lmts.dbf' SIZE 50m     EXTENT MANAGEMENT LOCAL AUTOALLOCATE SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'LMTS'; TABLESPACE_NAME                             FILE_NAME                                    FILE_ID LMTS                                       C:\ORACLEXE\ORADATA\XE\LMTS.DBF            9 SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'LMTS';
Read more

mariadb cluster

-
[root@localhost Desktop]# yum install MariaDB-server MariaDB-client Loaded plugins: aliases, changelog, downloadonly, fastestmirror, kabi, presto, refresh-packagekit, security, tmprepo, verify, versionlock Loading support for CentOS kernel ABI Loading mirror speeds from cached hostfile  * base: mirror.leapswitch.com  * extras: mirror.leapswitch.com  * updates: mirror.leapswitch.com mariadb                                                                                                                               | 1.9 kB 00:00      mariadb/primary_db                  ...
Read more