| ©«¤l10 ¥DÃD7 ºëµØ0 ¿n¤À22 ÂI¦W0  §@·~¨t²ÎWIN7 ³nÅ骩¥»OFFICE2010 ¾\ŪÅv10 ©Ê§O¤k µù¥U®É¶¡2012-4-27 ³Ì«áµn¿ý2012-4-27 
 | 
 ««Øundotbs
| CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE 'E:\ORCLDATA\oradata\AS40029I\UNDOTBS2A.dbf' SIZE 2048M
 AUTOEXTEND ON NEXT   10M MAXSIZE UNLIMITED
 /
 
 ALTER SYSTEM set undo_tablespace=undotbs2 SCOPE=BOTH;
 
 DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES;
 
 --Ãö¸ê®Æ®w¤â°Ê§Rdatafile
 --«·s±Ò°Ê¸ê®Æ®w
 
 CREATE UNDO TABLESPACE "UNDOTBS1"
 DATAFILE 'E:\ORCLDATA\oradata\AS40029I\UNDOTBS01.dbf' SIZE 2048M
 AUTOEXTEND ON NEXT   10M MAXSIZE UNLIMITED
 /
 
 ALTER SYSTEM set undo_tablespace=undotbs1 SCOPE=BOTH;
 
 DROP TABLESPACE undotbs2 INCLUDING CONTENTS AND DATAFILES;
 
 --«·s±Ò°Ê¸ê®Æ®w
 | 
 |