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

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