ORACLE 10G³£ÓÃÃüÁî

---´´½¨±í¿Õ¼ä
create tablespace ±í¿Õ¼äÃû×Ö datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss01.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss02.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss03.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss04.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss05.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss06.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss07.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss08.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss09.dbf' size 2048M;
---´´½¨±í¿Õ¼ä
alter tablespace SYSAUX add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\sysaux02.dbf' size 512M;
alter   database   datafile   'E:\oracle\product\10.2.0\oradata\pluto\ysstech01.dbf'    offline   drop
create undo tablespace UNDOTBS2 datafile 'E:\oracle\product\10.2.0\oradata\pluto\undotbs02.dbf' SIZE 300M AUTOEXTEND ON;
alter system set UNDO_TABLESPACE=UNDOTBS2
DBA_ROLLBACK_SEGS
drop tablespace UNDOTBS1
-- Èç¹ûundo±í¿Õ¼äundotbs²»ÄÜÊÍ·Å¿Õ¼ä,Öؽ¨Ö®
-- ´´½¨±¸ÓÃundo±í¿Õ¼ä
create undo tablespace newundotbs datafile '$ORA_DATA/newundotbs01.dbf' size 1000m
/
-- Çл»undo±í¿Õ¼ä
alter system set undo_tablespace=newundotbs scope=spfile
/
shutdown immediate
/
startup
/
-- dropÔ­±í¿Õ¼ä
drop tablespace undotbs including contents and datafiles
/
-- ´´½¨Ô­undo±í¿Õ¼ä
create undo tablespace undotbs datafile '$ORA_DATA/undotbs01.dbf' size 1000m
/
-- Çл»undo±í¿Õ¼ä
alter system set undo_tablespace=undotbs scope=spfile
/
-- ¹Ø±ÕÖØÆ𲢰ѱ¸