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(一品黄山) silverlight连接数据库出错 求大神…… Oracle出现异常,报:ORA-07445: 出现异常错误: 核心转储 oracle sql server 2005导出到oracle 10g中报错 在11g中。我解开了HR用户了。可是登录时还是提示:“应用程序要求的数据库权限超出了您当前具有的权限。有关特定版本的详细信息, 请单击“帮助”。” 我最近在面试,请教各位大神说一些数据库的知识。谢谢了 一个sql的问题 能否把括号去掉达到同样的效果 请各位师兄师姐师弟师妹们帮忙解决一个查询语句 oracle lsnctrl的疑问 如何实现两个表之间的___级联更新 在线等待,散尽分数,拚血求知
试一下
怎么去掉?
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(一品黄山)