-- 查看表空间的名字及文件所在位置
select tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
from dba_data_files
order by tablespace_name;
datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\xkzsp_log_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
-- 修改表空间大小 alter database datafile '表空间位置'resize 新的尺寸
alter database datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\xkzsp_log_data.DBF' autoextend on next 100m maxsize 10000m
select tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
from dba_data_files
order by tablespace_name;
--创建表空间
create tablespace xkzsp_log_data
loggingdatafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\xkzsp_log_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
-- 修改表空间大小 alter database datafile '表空间位置'resize 新的尺寸
alter database datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\xkzsp_log_data.DBF' resize 4000m;
alter database datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\xkzsp_log_data.DBF' autoextend on next 100m maxsize 10000m