1.create tablespace:
相关视图:
dba_tablespaces;
dba_data_files;
v$tempfile
dba_temp_files;
create tablespace aa datafile 'E:\oracle\product\10.2.0\oradata\stream\aa.dbf'
size 10m autoextend on;
CREATE SMALLFILE TABLESPACE "AA" LOGGING
DATAFILE '/oracle/app/oracle/oradata/lv_001' SIZE 8191M, '/oracle/app/oracle/oradata/lv_002' SIZE 8191M
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 20M SEGMENT SPACE MANAGEMENT AUTO;
create tablespace mas datafile '+ORCL_DATA1' size 1024M
autoextend on next 1024m maxsize unlimited
extent management local autoallocate
segment space management auto;
create temporary tablespace temp2
tempfile 'E:\oracle\product\10.2.0\oradata\stream\TEMP02.dbf' size 5M;
2. 修改表空间
增加表空间的数据文件:
alter tablespace eximtrx
add datafile
'/dev/vg01/reximdb_excmtrx02_25g' size 25500m,
'/dev/vg01/reximdb_excmtrx03_25g' size 25500m,
'/dev/vg01/reximdb_excmtrx04_25g' size 25500m;
将表空间更改为自动增长模式:
alter database datafile 'E:\oracle\product\10.2.0\oradata\stream\aa.dbf'
autoextend on;
ALTER DATABASE tempfile 'E:\oracle\product\10.2.0\oradata\stream\TEMP02.dbf'
AUTOEXTEND on;
增加临时表空间的数据文件:
alter tablespace temp2 add tempfile 'E:\oracle\product\10.2.0\oradata\stream\temp03.dbf'
size 10M;
3. 转移表所在的表空间:
alter table aa move tablespace cc;
4.resize表空间
ALTER DATABASE DATAFILE '/dev/vg01/file.dbf' RESIZE 999M;
5.删除创建错的数据文件
alter database drop datafile dropdfname offline drop;
alter database tempfile 'C:ORACLEORADATATESTTEMP02.dbf' offline;
alter database tempfile 'C:ORACLEORADATATESTTEMP02.dbf' drop;
Delete the physical datafiles belonging to the tablespace;
#删除这个表空间的所有物理的数据文件。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10322123/viewspace-610364/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10322123/viewspace-610364/