下面是我创建的表空间
create TABLESPACE netbaisdata DATAFILE
'c:\bais2\baisdata01.dbf' SIZE 1024M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
现在空间有点不够了,怎么在原有的基础上面增加表空间。帮忙写下语句
create TABLESPACE netbaisdata DATAFILE
'c:\bais2\baisdata01.dbf' SIZE 1024M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
现在空间有点不够了,怎么在原有的基础上面增加表空间。帮忙写下语句
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;2. 建立表空间
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M; 3.删除表空间
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES; 4. 修改表空间大小
alter database datafile '/path/NADDate05.dbf' resize 100M 5.增加表空间
ALTER TABLESPACE NEWCCS ADD DATAFILE '/u03/oradata/newccs/newccs04.dbf' SIZE 4896M;http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4681973.aspx
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
'c:\bais2\baisdata02.dbf' SIZE 1024M 文件路径和命名自己改,大小也按自己需要修改。