show parameter undo_tablespace;这个指定使用哪个回滚段。。额,你是说回滚段表空间吗
是啊是啊 我刚建的是一个混滚段空间 怎样查询以前undo表空间的信息
SQL> select * from v$tablespace; TS# NAME INC BIG FLA ENC ---------- ------------------------------ --- --- --- --- 0 SYSTEM YES NO YES 1 SYSAUX YES NO YES 2 UNDOTBS1 YES NO YES 4 USERS YES NO YES 3 TEMP NO NO YESSQL> select dbms_metadata.get_ddl('TABLESPACE','UNDOTBS1') from dual;DBMS_METADATA.GET_DDL('TABLESPACE','UNDOTBS1') ----------------------------------------------------------------------------- CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\ORA11\UNDOTBS01.DBF' SIZE 26214400 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\ORA11\UNDOTBS01.DBF' RESIZE 230686720
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YESSQL> select dbms_metadata.get_ddl('TABLESPACE','UNDOTBS1') from dual;DBMS_METADATA.GET_DDL('TABLESPACE','UNDOTBS1')
----------------------------------------------------------------------------- CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\ORA11\UNDOTBS01.DBF' SIZE 26214400
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ALTER DATABASE DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\ORA11\UNDOTBS01.DBF' RESIZE 230686720