temp文件不参加启动
今天联系了很多关于temp :
1、temp不参加启动；2、自动生成temp01;3、
Select * From v$sql_workarea_active tempseg_size tablespace有数据的时候表示排序使用了temp表空间，否则使用buffer cache排序；4、缩小数据文件alter table a enable row movement; alter table t shrink space cascade (delete and insert rowid改变)；Alter Database Datafile 'D:NEWORADATAUSER01.DMP' Resize 10m
[@more@]Select * From dba_tablespaces
Select * From dba_data_files
Select * From database_properties
Select * From dba_users
Alter Tablespace user02 Rename To user01
Alter Database Tempfile 'F:oradataora10gtemp01.dbf' Resize 3m
Alter Database Datafile 'F:oradataora10gusers01.dbf' Resize 8m
Alter Database Tempfile 'D:NEWORADATATEMP01' Resize 2m
Alter Database Datafile 'D:NEWORADATAUSER01.DMP' Resize 100m
Select Unique sid From v$mystat
Select * From test.t Order By Name
Select Count(*) From test.t
Delete test.t Where Rownum <= 45000
Select Sum(bytes)/1024/1024,Sum(bytes) From dba_extents Where segment_name = 'T' And OWNER='TEST'
1.75
Alter Table test.t Enable Row Movement
Alter Table test.t Shrink Space Cascade
Select * From dba_ts_quotas --quota
Alter User test Quota Unlimited On user01
Alter User test Quota 2m On temp01
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/450962/viewspace-1027023/ ，如需转载，请注明出处，否则将追究法律责任。
