oracle下的奇怪文件? check properly :select file_name ,tablespace_name,bytes,blocks,status from dba_data_files 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mv xxx.dat xxx.dat.bak试一下 列表中有!怎么去掉?TABLESPACE_NAME BYTES BLOCKS STATUS------------------------------ ---------- ---------- ---------/oradisk/oracle/app/oracle/oradata/ems/system01.dbfSYSTEM 183500800 11200 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/oemrep01.dbfOEM_REPOSITORY 5242880 320 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/rbs01.dbfRBS 12582912 768 AVAILABLEFILE_NAME--------------------------------------------------------------------------------TABLESPACE_NAME BYTES BLOCKS STATUS------------------------------ ---------- ---------- ---------/oradisk/oracle/app/oracle/oradata/ems/temp01.dbfTEMP 12845056 784 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/users01.dbfUSERS 5253038080 320620 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/indx01.dbfINDX 10485760 640 AVAILABLEFILE_NAME--------------------------------------------------------------------------------TABLESPACE_NAME BYTES BLOCKS STATUS------------------------------ ---------- ---------- ---------/oradisk/oracle/tabspace/datafile1.datEMS_TB_SP 1048576000 64000 AVAILABLE/oradisk/oracle/tabspace/rollbk.datROLLBACK 52428800 3200 AVAILABLE/oradisk/oracle/tabspace/EMS_RB.dataRB_EMS 52428800 3200 AVAILABLE9 rows selected. 搞定了!!!多谢sun9989(一品黄山) PostgreSQL默认安装好新建数据库以后用户名跟密码是什么啊? 各位大虾帮忙 win7安装oracle的问题,无法创建数据库 TNS: 协议适配器错误 求助!!! 一个sql查询问题 急死了,oem打不开 SQL优化问题求助 求助,solaris 5.8支持oracle多少版本?求该版本的下载链接 db_file_name_convert参数的疑问 菜鸟问题:如何得到一个日期加上天数后的日期? 如何实现两个表之间的___级联更新 在线等待,散尽分数,拚血求知
试一下
怎么去掉?
TABLESPACE_NAME BYTES BLOCKS STATUS
------------------------------ ---------- ---------- ---------
/oradisk/oracle/app/oracle/oradata/ems/system01.dbf
SYSTEM 183500800 11200 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/oemrep01.dbf
OEM_REPOSITORY 5242880 320 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/rbs01.dbf
RBS 12582912 768 AVAILABLE
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES BLOCKS STATUS
------------------------------ ---------- ---------- ---------
/oradisk/oracle/app/oracle/oradata/ems/temp01.dbf
TEMP 12845056 784 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/users01.dbf
USERS 5253038080 320620 AVAILABLE/oradisk/oracle/app/oracle/oradata/ems/indx01.dbf
INDX 10485760 640 AVAILABLE
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES BLOCKS STATUS
------------------------------ ---------- ---------- ---------
/oradisk/oracle/tabspace/datafile1.dat
EMS_TB_SP 1048576000 64000 AVAILABLE/oradisk/oracle/tabspace/rollbk.dat
ROLLBACK 52428800 3200 AVAILABLE/oradisk/oracle/tabspace/EMS_RB.data
RB_EMS 52428800 3200 AVAILABLE
9 rows selected.
多谢sun9989(一品黄山)