...olumn status for a15select status, file_name, tablespace_name, bytes/1024/1024 "Size(M)", AUTOEXTENSIBLE from dba_data_files union allselect status, file_name, tablespace_name, bytes/1024/1024 "Size(...
...>select blocks*(db_block_size的值)/1024/1024 from v$datafile 查看数据文件是否自动扩展SQL>select file_name, autoextensible, maxbytes/1024/1024/1024 from dba_data_files;Autoextensible为是否自动扩展标记,maxbytes为数据文件最大扩展直接,这里单位为G 查看临...
...正确 数据文件使用裸设备时,文件不可自动扩展(使用文件系统的数据文件也建议不设成自动扩展):Sql>select file_name,tablespace_name,status,autoextensible from dba_data_files where autoextensible<>'NO';Sql>alter database datafile '****' autoext...
...instance; 3.临时表空间数据文件情况:col file_name format a30select file_name,tablespace_name,bytes/1024/1024 MB,autoextensible from dba_temp_files; select name,log_mode,open_mode from v$database;archive log list select tablesp...
...oradata/radius/undo.dbf' resize 10240m;5.设置表空间不足时自动增长5.1查看表空间是否自动增长SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files;5.2 设置表空间自动增长ALTER DATABASE DATAFILE 'c:\SmartDB01.ora' AUTOEXTEND ON;//打开自动增长
...ess = b.addressorder by address, piece; 二、查看数据库文件情况(大小、是否扩展等)SELECT T.TABLESPACE_NAME,D.FILE_NAME,D.AUTOEXTENSIBLE,D.BYTES,D.MAXBYTES,D.STATUSFROM DBA_TABLESPACES T,DBA_DATA_FILES DWHERE T.TABLESPACE_NAME =D.TABLES...
...column file_name format a60;set linesize 160;select file_name,round(bytes/(1024*1024),0)total_space,autoextensible,increment_by*&blksz/(1024*1024) asincement,maxbytes/(1024*1024) as maxsize from dba_data_files ...
...sSQL>from dba_tablespacesSQL>where contents =’undo’; SQL>select tablespace,file_name,bytes,autoextensibleSQL>from dba_data_files;SQL>where tablespace_name = ‘my_undo’; 17.5还原表空间的维护1.重命名还原表空间SQL>al...
...认当前的临时表空间为TEMP2、查看目前临时表空间的大小:SQL>select file_name,tablespace_name,bytes/1024/1024 "MB",autoextensible from dba_temp_files;3、创建新的临时表空间:(先在其他的磁盘空间借用一下空间)SQL> create temporary tablespace temp022 tempfi...