-
编辑 删除
RAC 用户权限错误
错误代码ORA-01565: error in identifying file '+DATA/ruirui/spfileruirui.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/ruirui/spfileruirui.oraORA-01031: insufficient privileges描述：RAC 用户id需要...
-
编辑 删除
统计用户表对应字段
select TABLE_NAME,COLUMN_NAME,DATA_TYPE from user_tab_columns;
-
编辑 删除
About Static Data Dictionary Views
1.静态数据字典视图：Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to...
-
编辑 删除
rman 备份 全库
run{allocate channel d1 type disk maxpiecesize=50G;allocate channel d2 type disk maxpiecesize=50G;backup full database filesperset 10 include current controlfile format '/backup/fullbak_%d_%T_%s_%...
-
编辑 删除
TEMPORARY Tablespaces and TEMPFILES 详细解释
What are Temporary Tablespaces:Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracl...
-
编辑 删除
TEMPORARY Tablespaces and TEMPFILES
具体需求： 安装完oracle 10g DATA GUARD 需要修改tempfile参数 刚装好DATA GUARD 时 tempfile 大小为 30M 需要对其修改查询当前tempfile 大小 和数据文件SELECT NAME, bytes/1024/1024 ...
