1. 首页
  2. IT资讯

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_tablespacesSelect * From dba_data_filesSelect * From database_propertiesSelect * From dba_usersAlter Tablespace user02 Rename To user01Alter Database Tempfile ‘F:oradataora10gtemp01.dbf’ Resize 3mAlter Database Datafile ‘F:oradataora10gusers01.dbf’ Resize 8m

Alter Database Tempfile ‘D:NEWORADATATEMP01’ Resize 2mAlter Database Datafile ‘D:NEWORADATAUSER01.DMP’ Resize 100mSelect Unique sid From v$mystatSelect * From test.t Order By NameSelect Count(*) From test.tDelete test.t Where Rownum <= 45000Select Sum(bytes)/1024/1024,Sum(bytes) From dba_extents Where segment_name = 'T' And OWNER='TEST'1.75Alter Table test.t Enable Row MovementAlter Table test.t Shrink Space CascadeSelect * From dba_ts_quotas --quotaAlter User test Quota Unlimited On user01Alter User test Quota 2m On temp01

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027023/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194878.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code