创建表空间及添加数据文件

创建表空间及添加数据文件

1、创建表空间

create tablespace tablespacename

datafile ‘/u02/oradata/$ORACLE_SID/datafilename’size128M

autoextend on next 2048K

maxsize2048M,

‘u02/oradata/$ORACLE_SID/datafilename’ size128M

autoextend on next 2048K

maxsize2048M

logging

extent management local autoallocate

segment space management auto

flashback on

2、添加数据文件

alter tablespace tablespacename add datafile

‘u02/oradata/$ORACLE_SID/datafilename’size128M

autoextend on next 2048K

maxsize2048M