常用sql

• Oracle

//创建表空间

 

CREATE TABLESPACE nbhbdc
LOGGING
DATAFILE 'E:\app\oradata\orcl\nbhbdc.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL;

//创建临时表空间
CREATE TEMPORARY TABLESPACE nbhbdc_temp
TEMPFILE 'E:\app\oradata\orcl\nbhbdc_TEMP.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL;